Thread: numbers to text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Roger is offline
external usenet poster
 
Posts: 226
Default numbers to text

is there an "easy" way to change a number (dollar value) into text and have
all the zeros stay in place:

45.00 (number) change to text -- 4500
4.75 (number) change to text -- 475

probably a macro, but I wouldn't even know how to start. hope someone can
push me in the right direction.

Thanks in advance.