| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel auto-divide numerical inputs by 100?
For some reason, Excel started dividing all my integer inputs by 100? Does anyone know why this is happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does Excel auto-divide numerical inputs by 100?
Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting. This setting is useful if you want to enter a large number of dollars and cents values but don't want to type the decimal point. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 17 Feb 2009 13:16:25 -0800, CurtisB wrote: For some reason, Excel started dividing all my integer inputs by 100? Does anyone know why this is happening? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does Excel auto-divide numerical inputs by 100?
Tools/ Options/ Edit
Unset "Fixed decimal places" -- David Biddulph CurtisB wrote: For some reason, Excel started dividing all my integer inputs by 100? Does anyone know why this is happening? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does Excel auto-divide numerical inputs by 100?
.... Because the ToolsOptionsEditFixed Decimal Places check box was checked! "CurtisB" wrote: For some reason, Excel started dividing all my integer inputs by 100? Does anyone know why this is happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto divide option | Excel Discussion (Misc queries) | |||
| How can I make graphics with 5 inputs in Excel 2003? | Charts and Charting in Excel | |||
| Auto save with a numerical number | Excel Discussion (Misc queries) | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Linear Mode
