MrExcel Publishing
Your One Stop for Excel Tips & Solutions

convert numbers to words


Posted by Paul on December 24, 2000 7:46 AM

Is there a formula that would convert a number in a cell to words? For example if cell A1 contained 10,525.25 I want the formula in cell B2 to return ten thousand five hundred twenty five dollars and twenty five cents. Thanks in advance for your help. Paul


Posted by Dave on December 24, 2000 11:24 AM


Hi Paul

There is no standard Excel formula that will do this. I do remember once seeing an Add-in that could be downloaded (at a price) that claims to be able to do this. However I'm can't remember where is was :( and I don't think it was this flexible i.e it only worked on numbers divisible by 10.

You may be able to use this work around:

In B1 type =A1 then go to Format>Cells>Custom and using one of the pre-defined formats as a starting point type "ten thousand five hundred twenty five dollars and twenty five cents" with the quotations. The underlying value of the cell will still be numeric.


Good Luck and Merry Christmas

Dave
OzGrid Business Applications

Posted by Celia on December 24, 2000 5:11 PM


There is a function to do what you want at :-
(broken link)
Look at NumToText.zip

Celia

Posted by GoodFaith on December 25, 2000 5:54 AM

Go to http://www.elementkjournals.com/ime/9710/ime97a1.htm. This is a public article of Inside Microsoft Excel archive. Its method (function) only works with numbers within a preset range of 1,000,000--0.

Merry Christmas.