| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Need help with an embedded IF statement | Excel Worksheet Functions | |||
| Enter 2 dates in same excel cell | Excel Discussion (Misc queries) | |||
| Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
| Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Hybrid Mode
