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

Hi Mark

Somehow fixed decimal places has got set.
Go to ToolsOptionsEdit and uncheck Fixed Decimal places.

--
Regards

Roger Govier


"markvr6" wrote in message
...
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

Pull-down:

Tools Options... General and clear Fixed decimal
--
Gary's Student


"markvr6" wrote:

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