Jun 23 2020 03:51 AM
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!
Jun 23 2020 04:41 AM
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-for...
You may google for other variants with formula (it's always big enough) or VBA function.
Jun 23 2020 04:54 AM
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
Jun 23 2020 05:04 AM
Thank you @Sergei Baklan,
I saw the formula, but I was hoping for a built-in formula... maybe in a couple of years. :)
Jun 23 2020 05:08 AM
Unfortunately no such built-in. Not sure it will be added, mainly due to complexity of localization. But who knows.