Dollars to text without loosing zeros from decimal places

[DOK]

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

 

[David Biddulph]

=TEXT(A1,"0.00") or =TEXT(A1,"$#.00"), depending on whether or not you want
the $ symbol.

 

[Peo Sjoblom]

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]

Thank you but this still gives me a decimal point which must be removed or it
rounds up to the next whole number.

 

[Peo Sjoblom]

Where did you state that the decimal point must be removed in your original
post? You only said you wanted the decimals to remain? Just multiply with
100, then copy and paste special as values, then format as text.



--


Regards,


Peo Sjoblom

 

[Gord Dibben]

=TEXT(A1,"00")*100


Gord Dibben MS Excel MVP