Why does 100 turn into 1 when I enter it into a cell?

[Guest]

I typed the number 100 in a cell and it automatically turned into 1.
Similarily, when I typed the number 1, it automatically turned into 0.01.
Excel is dividing every number I type by 100. Does anyone know why that is
and how I can fix it?

 

[Guest]

Check your format to see if it is set to percent for that cell or range of
cells.

 

[Bob Phillips]

Check Tools>Options>Edit and uncheck the Fixed Decimal checkbox.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Niek Otten]

Tools>Options>Edit tab, Uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I typed the number 100 in a cell and it automatically turned into 1.
| Similarily, when I typed the number 1, it automatically turned into 0.01.
| Excel is dividing every number I type by 100. Does anyone know why that is
| and how I can fix it?