Thread: Why?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege
 
Posts: n/a
Default Why?

Anoli

Look at Tools/Options/Edit
Make sure "fixed decimal places" is not checked
Also, check the cell format, may be Number/No decimal places or Custom/ 0

Beege


"Anoli" wrote in message
...
I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?