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

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

danh wrote:
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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"danh" wrote in message
...
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

Perhaps

http://support.microsoft.com/default...B;EN-US;213360

will help

--


danh Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535445