change data into text format

[Guest]

Im working in excel, producing a form!

In one cell i have a sum that is in $$$$....ie $1000.

In another cell i want it to automaticly change from $1000 to 'one thousand
dollars' (in text).....can you do this?
ive noticed you can do it into thai! so hopefully can do it in english

Thanks

 

[Guest]

try out this small custom function straight from miscrosoft help

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

U need to customize it to your need.