Discussion Locked

Entering a '1' gives me '0.01'

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
On a new spreadsheet, entering a 1 in a field changes to a "0.01" in the cell. It's not related to the 'Automatic Percent Entry', so what could it be? I've copied the file to another PC running Excel and it doesn't happen, so it's specific to the one PC. What could be causing it?

4 replies

by jireland607

Go to tools - options

Select the edit tab

Uncheck the option "Fixed decimal places"

You should find this solves your problem

by kbowz

Thank you. That was the problem. I spent several days just for one checkbox. Thank you again.

by misscrf

If the previous answer doesnt work, make sure to check the field format, and look in the cell's formula field up top. Right click the field, format field and make sure the cell is formatted to the right field type.

There is a toolbar button that will make a field have a decimal to it, and it is easy to push it, changing the field type, without seeing that you did.

Make the field general. Click ok, delete the number and put 1 in again.

Let us know how it works out.

This discussion is closed to new replies.