ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does 100 turn into 1 when I enter it into a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/114513-why-does-100-turn-into-1-when-i-enter-into-cell.html)

Ashley Luo

Why does 100 turn into 1 when I enter it into a cell?
 
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?

JLGWhiz

Why does 100 turn into 1 when I enter it into a cell?
 
Check your format to see if it is set to percent for that cell or range of
cells.

"Ashley Luo" wrote:

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?


Bob Phillips

Why does 100 turn into 1 when I enter it into a cell?
 
Check ToolsOptionsEdit and uncheck the Fixed Decimal checkbox.

--
HTH

Bob Phillips

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

"Ashley Luo" <Ashley wrote in message
...
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?




Niek Otten

Why does 100 turn into 1 when I enter it into a cell?
 
ToolsOptionsEdit tab, Uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ashley Luo" <Ashley wrote in message ...
|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?




All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com