Enter "1", cell show ".01". Why?

G

Guest

Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?
 
M

Max

Try this ..

Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK

Things should be back to normal now ..

(it's a fixed decimal setting !)
 
G

Guest

If you format a cell as a date, and then you type 1 in the cell it will
display as 1 Jan 1900.
Similarly, you have some format enabled that displays 1 as .01 Clear the
formats in the affected cells, or format them as type number or General and
you will have the entered numbers displaying correctly.
To format, select the affected cells, right click and choose format
Hope that helps
 

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

Number automatically divided by 100, why? 4
Why does 100 turn into 1 when I enter it into a cell? 3
Input numbers appearing incorrectly on spreadsheet 2
I don't need the actual value but what is shown 2
default format for Excel numbers 3
Time Conversion issue 5
When I type in 100 a 1 appears, 10000 and 100 appear 2
Numbers showing Up Centered in Cell ? 1

Top