| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange autoformat occurrence
For some reason, Excel started multiplying all of my cells containing numbers
by a factor of 0.1. So if I want to input "6", I have to type "60". It even alters cells from older files if I click on a cell with a number. How can I correct this issue? Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strange autoformat occurrence
Click TOOLS, OPTIONS and then click the EDIT tab. Locate the FIXED DECIMALS
check box and click to remove the check. Click OK to return to the worksheet and then resave your file. -- Kevin Backmann "jojoro50" wrote: For some reason, Excel started multiplying all of my cells containing numbers by a factor of 0.1. So if I want to input "6", I have to type "60". It even alters cells from older files if I click on a cell with a number. How can I correct this issue? Thanks, Josh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strange autoformat occurrence
Thank You!!!
"Kevin B" wrote: Click TOOLS, OPTIONS and then click the EDIT tab. Locate the FIXED DECIMALS check box and click to remove the check. Click OK to return to the worksheet and then resave your file. -- Kevin Backmann "jojoro50" wrote: For some reason, Excel started multiplying all of my cells containing numbers by a factor of 0.1. So if I want to input "6", I have to type "60". It even alters cells from older files if I click on a cell with a number. How can I correct this issue? Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autoformat | Excel Worksheet Functions | |||
| Occurrence between rows | Excel Discussion (Misc queries) | |||
| Strange Occurrence Copying Formula | Excel Discussion (Misc queries) | |||
| Frequency of occurrence | Excel Discussion (Misc queries) | |||
| find last occurrence | Excel Worksheet Functions | |||
Linear Mode
