number to text

[emese705]

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!

[#2]

@emese705 

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.

[#3]

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

[#4]

@Bennadeau 

That could be quite big table...

[#5]

Thank you @Sergei Baklan,

I saw the formula, but I was hoping for a built-in formula... maybe in a couple of years. :)

[#6]

@emese705 

Unfortunately no such built-in. Not sure it will be added, mainly due to complexity of localization. But who knows.

[#7]

thanks! @Bennadeau