change data into text format
 

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

change data into text format
 

try out this small custom function straight from miscrosoft help

http://support.microsoft.com/default...b;en-us;213360

U need to customize it to your need.


"pleasehelpthanks" wrote:

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