Log in

View Full Version : Excel digits convert into text?


thegreatwolf
Jan 20, 2011, 05:49 AM
I just want to know that if I enter some value like "1000"
it can b change into text form like "one thousand"
if there is any formula *** tell me
this is my mailing address >Removed<

JBeaucaire
Jan 20, 2011, 08:29 AM
No there is no built-in Excel function to convert numbers to word-text. You can add that functionality in.

Here's a page that offers a User-Defined-Function call SpellNumber that you can install into your workbook and use.

Excel: Convert Numbers to Words/Text (http://www.ozgrid.com/VBA/ValueToWords.htm)

If you Google: converting excel numbers to text you'll tons more just like it. This isn't an uncommon desire.