Excel automatically divides number by 100

[Ravi Budhia]

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

 

[Kevin B]

Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check
from the FIXED DECIMALS PLACES checkbox to solve the problem.

 

[David Biddulph]

Tools/ Options/ Edit
Uncheck: Fixed decimal places

 

[Ravi Budhia]

Thanks Kevin! That fixed the problem!

Ravi

Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check
from the FIXED DECIMALS PLACES checkbox to solve the problem.