Tools/ Options/ Edit
Uncheck: Fixed decimal places
--
David Biddulph

"Ravi Budhia" <Ravi wrote in message
...
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