Forum Discussion
emese705
Jun 23, 2020Copper Contributor
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...
SergeiBaklan
Jun 23, 2020Diamond Contributor
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.
- emese705Jun 23, 2020Copper Contributor
Thank you SergeiBaklan,
I saw the formula, but I was hoping for a built-in formula... maybe in a couple of years. 🙂
- SergeiBaklanJun 23, 2020Diamond Contributor
Unfortunately no such built-in. Not sure it will be added, mainly due to complexity of localization. But who knows.