Forum Discussion
number to text
Hello, Does anyone know if there is an excel formula or function for number transformation from digits to text? This expression has to recognize each value between 0 to 99 which we can change in a c...
Hi emese705,
There's two different ways I can think of. If you are ok with using Macros, look this up. https://www.techonthenet.com/excel/formulas/number_to_words.php
The other method would be to create a table where you pre-populate the values and then using a simple vlookup you can find the match in your table.
Ben
