View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Cell Entries show as decimal

Sounds like you've set fixed decimal places.

Goto ToolsOptionsEdit tabuncheck Fixed decimal placesOK

--
Biff
Microsoft Excel MVP


"Saskatoon Jerry" wrote in
message ...
Cell entry 100 shows as 0.01. What to do?
--
Saskatoon Jerry