Value trouble!!!

[Guest]

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

 

[Bob Phillips]

Goto Tools>Options 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)

 

[Guest]

Wow!!!
Thankyou for your reply, I cd solve the problem, thankyou very very much!!!

Sim