Translate figures to characters

[danh]

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=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

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"danh" <[email protected]> wrote in message
news:[email protected]...
> 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