Excel automatically deviding value by 100...
 

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

Excel automatically deviding value by 100...
 

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)

"Irfan Khan" wrote in message
...
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