View original (French)

Convert a number to text in Excel without macro

Solved
vincentphilippos Posted messages 2 Status Member -  
tontong Posted messages 2575 Registration date   Status Member 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 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member 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