I try to enter info in a cell - type 0.77 and it changes to 1. How do I change it back?
A Anoli Mar 20, 2006 #1 I try to enter info in a cell - type 0.77 and it changes to 1. How do I change it back?
B Beege Mar 20, 2006 #2 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 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
T Trevor Shuttleworth Mar 20, 2006 #3 You could try increasing the number of decimal places displayed. Click on the Increase Decimal icon on the Formatting Menu bar a couple of times. Note: a more specific description of your problem would get more people to look and maybe respond. Regards Trevor
You could try increasing the number of decimal places displayed. Click on the Increase Decimal icon on the Formatting Menu bar a couple of times. Note: a more specific description of your problem would get more people to look and maybe respond. Regards Trevor
