How I convert number to word
 

I am using excel 2003. looking for a formula which would convert number to
word.
Say, if i have 123 at cell A1 what should be formula at B1 which would
automatically display "One hundred twenty three".
How to use "Spelltext"?

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"swastik" wrote in message
...
I am using excel 2003. looking for a formula which would convert number to
word.
Say, if i have 123 at cell A1 what should be formula at B1 which would
automatically display "One hundred twenty three".
How to use "Spelltext"?