convert number to english text. example: 2=two, 100=hundred

[abiot]

I am a civil engineer working in 40,000,000 dollar road construction project
in ethiopia. And I am a quantity surveyor. after calculating payments in
excel, I want to convert the numbers to english text.
example: 1,200,345.47 equals "one million two hundred thousand three hundred
forty five and 47/100"

 

[xlm]

try this link which will do what you want

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360



--
If this posting was helpful, please click on the Yes button

Thank You

cheers,

 

[Ron@Buy]

This link also gives a solution:

http://www.xldynamic.com/source/xld.xlFAQ0004.html