Excel automatically deviding value by 100...

[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

 

[Ron Coderre]

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)