Translate figures to characters

[Guest]

Is there a function that translates figures to characters.
For exemple 1200 will say One thousand two hundred
451 will say four hundred and fifty-one

Thanks

 

[Andrew Taylor]

http://www.google.com/search?q=excel+numbers+to+words
and
http://groups.google.com/groups?q=excel+numbers+to+words
give lots of useful links.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bryan Hessey]

Perhaps

http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

will help

--