# Formulas: converting numbers (amounts) into Words

• I would like some help on how to convert numbers or amounts (456.86) into words (Four Hundred Fifty-Six and 86/100). Any help is appreciated..
I have Windows XP Professional with
Excel 2002

• In principle this could be done by writing VBA code to parse numbers based on where the decimal fell. But you would have to code the the word translation for each digit based on its position (e.g., is a 5 a five or a fifty, and is a one a one or the first half of twelve. How large a number might you encounter? You have to code up to that possibility. Will all number be to two decimal places (e.g., are we talking dollar amounts?)?

If you can write the math rules for the word parsing, then you can assign each parse to a variable and use the CONCATENATE function to glue them together (with appropriate spaces inserted).

• Hi Sparky,

The attached workbook contains a UDF called SpellNumber(). It us useful for check writing since it spells out currency like "One Hundred Fifty Dollars and Fourty Five Cents".

The UDF could easily be modified to remove the Dollars and Cents references if you don't need/want them.

Hope this helps

.....Ralph

• THANKS GUYS FOR YOUR HELP BUT STILL NOT WORKING.:(

• It might help if you were a litle more specific about the nature of the errors you are getting.

• It might help if you were a litle more specific about the nature of the errors you are getting.

Ok, What I am trying to do is use Excel 2002 as a check writer....I've setup up the page demensions to print right on a check. In order to save time with a volume of about 50 checks a week I would like to just type in one cell the amount and have the other cell converted into words. so the specific error is that when I formulate =SpellNumber(A1) it gives me NAME! "error":(:o:(

• You could visit asap-utilities.com and download their stuff. One includes what you're after.

Richard

If absence makes the heart grow fonder, and familiarity breeds contempt, perhaps my wife should live in Darwin?

• Re: Formulas: converting numbers (amounts) into Words

i am trying to convert number 20.18 (twenty dollors & 18/100)
Pls help me by pasting the code ...

• Re: Formulas: converting numbers (amounts) into Words

Shaikhfaraz,

Welcome to Ozgrid. Please do not post questions in other threads, this one is over 7 years old. Start your own thread with an appropriate title that should use Search Friendly Key Words and if necessary refer back to a previous thread if it is relevant.

Thank you.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!