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 cell, and display text description in another cell.
I have tried with REPLACE and SUBSTITUTE, but obviously it does not work if I change the numbers in the first cell...
Thank you!
6 Replies
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
That could be quite big table...
Even on this forum there are few solutions, first I found is the formula in this thread https://techcommunity.microsoft.com/t5/excel/how-to-convert-numbers-to-words-with-built-in-excel-formula/m-p/168783
You may google for other variants with formula (it's always big enough) or VBA function.
Thank you SergeiBaklan,
I saw the formula, but I was hoping for a built-in formula... maybe in a couple of years. 🙂
Unfortunately no such built-in. Not sure it will be added, mainly due to complexity of localization. But who knows.
