Use a help column and text function

=TEXT(A1,"$#,##0.00")


copy down as long as needed, then copy and paste special in place, then
export the help column or just copy and paste over the old data


--


Regards,


Peo Sjoblom


"DOK" wrote in message
...
I need to convert dollars to text but the decimal place digits must remain
since this will be converted to a txt file for file transfers. When I
convert $19,500.00 to text it becomes 19500 but I need the zeros from the
decimal places.
Your help is truly appreciated.
Thank you