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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the occurrence? 9
strange about ":" 2
How to find out the 3 highest occurrence of number from a list? 5
help on summing a random combination 1
How to multiply a number by a set of numbers 3
How to determine the occurrence between periods? 1
return a minimum value of 1, except when multiplied by an empty ce 6
Question about conditional formatting of zeros in Excel 0

Top