View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlm xlm is offline
external usenet poster
 
Posts: 55
Default convert number to english text. example: 2=two, 100=hundred

try this link which will do what you want

http://support.microsoft.com/default...b;en-us;213360



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

Thank You

cheers,









"abiot" wrote:

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"