How do I write a formula to convert numbers to written text?

[Jess]

I want to write a formula or figure out how to have a cell containing 1,000
and to have a corresponding cell to reflect the written text form example
"One Thousand"

 

[Bondi]

Hi Jess,

Have a look at this link

http://www.meadinkent.co.uk/xlnumberstext.htm

Regards,
Bondi

 

[Ron Coderre]

Try this website:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro