data changes when entered into a cell
 

All new and existing spreadsheets change the data as it is entered into a
cell. For example if you open a new workbook and enter 5 into Sheet 1 cell
A1, it immediately reads 0.05. I cannot understand why, even if there is no
formatting why this is happening. This has happened either last thing
yesterday, or first thing today, because yesterday it was fine. I guess
somewhere I have inadvertently checked a box , bt cannot find how to undo it.
Please help me.

data changes when entered into a cell
 

Go to Tools - Options and uncheck Fixed Decimal Places...
--
HTH...

Jim Thomlinson


"Ian Gill" wrote:

All new and existing spreadsheets change the data as it is entered into a
cell. For example if you open a new workbook and enter 5 into Sheet 1 cell
A1, it immediately reads 0.05. I cannot understand why, even if there is no
formatting why this is happening. This has happened either last thing
yesterday, or first thing today, because yesterday it was fine. I guess
somewhere I have inadvertently checked a box , bt cannot find how to undo it.
Please help me.