Numbers converted to percentage automatically

Maggie29 · External Since: Aug 03, 2007 Posts: 2

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 · External Since: Apr 13, 2004 Posts: 455

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

Maggie29 · External Since: Aug 03, 2007 Posts: 2

Thank you! That worked.

"Jan Karel Pieterse" wrote:

> 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
>
>