![]() |
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? |
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? |
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? |
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