Numbers converted to percentage automatically

[Guest]

When I open a spreadsheet and attempt to change the entries in cells that are
formatted as "Number", Excel treats the entry as a percentage no matter what
I do.

For example. A cell has the number 46 displayed correctly. I change the
number to 49, making no other formatting changes. Excel puts 0.49 in the
formula bar and 0 in the cell (depending on the number of decimal points).
If I enter 89, it will display .89 in the formula bar and 1 in the cell.

This does not happen when I open the file on a different computer. I am
working on a relatively new computer, but the problem did not start right
when I got it.

Is there a hidden setting somewhere?

 

[Jan Karel Pieterse]

Hi Maggie29,

For example. A cell has the number 46 displayed correctly. I change the
number to 49, making no other formatting changes. Excel puts 0.49 in the
formula bar and 0 in the cell (depending on the number of decimal points).
If I enter 89, it will display .89 in the formula bar and 1 in the cell.

Tools, options, Edit tab, remove check in box that says "Fixed decimal places".

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Guest]

Thank you! That worked.

Hi Maggie29,


Tools, options, Edit tab, remove check in box that says "Fixed decimal places".

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com