View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Gill Ian Gill is offline
external usenet poster
 
Posts: 1
Default 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.