View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default How to display numbers as text? Ex: 203 = "two hundred, three"

See these websites:

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

http://www.ozgrid.com/VBA/ValueToWords.htm


----------

Regards,

Ron
Microsoft MVP (Excel)


"Dann the Mann" <Dann the wrote in message
...
I'd like to try and automate converting numbers (ex 2035.92) int the text
equivalent
"Two Thousand Thirty Five, and 92/100"

Similar to how you "spell" a number on a bank check.