View original (French)

Convert a number to text in Excel without macro

Solved
vincentphilippos Posted messages 2 Status Membre -  
tontong Posted messages 2575 Registration date   Status Membre Last intervention   -
Hello,
I am looking to convert a number into letters in Excel but without using a macro.
Someone previously provided a great answer based on a series of =if() formulas, but I can't find it on the forum.
Please help me.

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
Here is a solution to convert a number (written with several digits) into words. This solution uses the power of a spreadsheet instead of a macro.
https://www.cjoint.com/c/HKlleFaJUiK
9