How do I set up number eg 2000 to word two thousand in excel?

[Guest]

I need to convert numbers in excel to words

Eg 2,200

Two thousand and two hundred dollars

 

[Squid]

Here is the code to create the function:

http://support.microsoft.com/?kbid=213360

 

[Frank Kabel]

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