Excel automatically divides number by 100

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am having a problem with Excel. Whenever I enter a number in a cell, excel
divides it by 100 and then stores it. So when I enter 12 for example, then
the number is stored as 0.12. A 100 is stored as 1. So seems like there is
some setting which is causing this. However, I am not able to figure out what.

Also, when I enter "=sum(100, 12)" in a cell, the number is stored correctly
as 112. Also, if the value is stored as text and then converted to a number,
the number is shown correctly.

I am using Excel 2003 SP2, on Windows XP Professional, and have the Solver
addin installed. This has started happening in the last couple of weeks.

Please help!

Thanks,

Ravi Budhia
 
Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check
from the FIXED DECIMALS PLACES checkbox to solve the problem.
 
Thanks Kevin! That fixed the problem!

Ravi

Kevin B said:
Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check
from the FIXED DECIMALS PLACES checkbox to solve the problem.
Click to expand...
 
Back
Top