Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sim" wrote in message
...
Hello all,
Whenever I am adding any value to a cell, the value by itself gets divided
by 100, that means if I am writing 1000, it shows the value of 10!!! And
if I
type 1000.0, then it shows the value 1000, I have checked the decimal
points
and everything seems to be ok!!! So, if I type 1234, it shows 12.34!!!
Please
help!!!