Value trouble!!!

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

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!!!
 
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)
 
Back
Top