Strange autoformat occurrence

J

jojoro50

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
 
K

Kevin B

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.
 
J

jojoro50

Thank You!!!

Kevin B said:
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.
Click to expand...
 
Top