View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd G
 
Posts: n/a
Default Keep Trailing Zeros When Convert To Text

Is there a way any one knows about to keep the 00 portion with the dollar
amount when you convert to a text format.
e.g. $234.00 converted to text to be 23400, not like it automatically does
234.

The other amounts where there are actual cents work fine as we all know, but
I need everything, no matter if there are pennies or not.