View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default 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