View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marie Marie is offline
external usenet poster
 
Posts: 143
Default Keep the ".00" for a number.

I have a column for currency. When I type in "25.00" it will show on the
spreadsheet as 25.00. HOWEVER the actual value has been auto formatted to
"25". I need to restrict this default setting since I am using the data for a
mail merge. As of now the mail merge will now display "25" instead of
"25.00".

I can't figure out how to change this!

Thanks