Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record changing cell data into a column or range | Excel Worksheet Functions | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Moving a line of data when information is entered in a specific cell. | Excel Discussion (Misc queries) |