View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Dollars to text without loosing zeros from decimal places

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

"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