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
|