Excel automatically deviding value by 100...

  • Thread starter Thread starter Irfan Khan
  • Start date Start date
I

Irfan Khan

Whenever i am enetering any number in excel it is automatically deviding it
by 100 like if I enter 2 then it will store as 0.002. Whenever I am having
any formula calculation then there is no prblem .... Can anybody help me ???


Thanks a lot
 
Try this:

From the Excel Main Menu:
<tools><options><edit tab>
UNcheck: Fixed Decimal Places

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top