numbers problem

M

markvr6

I have a spreed sheet which I have been using for 12 months,
now everytime I type in a digit and hit enter the single digit is displayed
as decimal. ie 7 end as 0.0007
 
R

Roger Govier

Hi Mark

Somehow fixed decimal places has got set.
Go to Tools>Options>Edit and uncheck Fixed Decimal places.
 
Top