number to text

%3CLINGO-SUB%20id%3D%22lingo-sub-1483286%22%20slang%3D%22en-US%22%3Enumber%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483286%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20there%20is%20an%20excel%20formula%20or%20function%20for%26nbsp%3Bnumber%20transformation%20from%20digits%20to%20text%3F%20This%20expression%20has%20to%20recognize%20each%20value%20between%200%20to%2099%20which%20we%20can%20change%20in%20a%20cell%2C%20and%20display%20text%20description%20in%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20with%20REPLACE%20and%20SUBSTITUTE%2C%20but%20obviously%20it%20does%20not%20work%20if%20I%20change%20the%20numbers%20in%20the%20first%20cell...%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1483286%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483395%22%20slang%3D%22en-US%22%3ERe%3A%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483395%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707054%22%20target%3D%22_blank%22%3E%40emese705%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20two%20different%20ways%20I%20can%20think%20of.%20If%20you%20are%20ok%20with%20using%20Macros%2C%20look%20this%20up.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.techonthenet.com%2Fexcel%2Fformulas%2Fnumber_to_words.php%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.techonthenet.com%2Fexcel%2Fformulas%2Fnumber_to_words.php%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20method%20would%20be%20to%20create%20a%20table%20where%20you%20pre-populate%20the%20values%20and%20then%20using%20a%20simple%20vlookup%20you%20can%20find%20the%20match%20in%20your%20table.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EBen%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483378%22%20slang%3D%22en-US%22%3ERe%3A%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707054%22%20target%3D%22_blank%22%3E%40emese705%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20on%20this%20forum%20there%20are%20few%20solutions%2C%20first%20I%20found%20is%20the%20formula%20in%20this%20thread%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-to-convert-numbers-to-words-with-built-in-excel-formula%2Fm-p%2F168783%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-to-convert-numbers-to-words-with-built-in-excel-formula%2Fm-p%2F168783%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EYou%20may%20google%20for%20other%20variants%20with%20formula%20(it's%20always%20big%20enough)%20or%20VBA%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@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.

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

 
 

 

 

 

@Bennadeau 

That could be quite big table...

Thank you @Sergei Baklan,

 

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

@emese705 

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

thanks! @Bennadeau