data changes when entered into a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
enter date&time into cell 2
How can I stop format change when copying data into unlocked cells 1
Why won't target cell data changes trigger formula evaluation? 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Entering Identical Data in a Designated New Cell 4
Entering 'GTi' but I get 'Gti' ! 2
Auto enter current date in cell when another changed 7

Back
Top