View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff
 
Posts: n/a
Default numbers automatically format

When I input a # into a cell, even though the cell is not formatted, it
automatically removes two decimal places. For example if I input the number
2, when I press enter it shows .02, it is not formatted for percentage or for
currency but general number.