Excel automatically dividing 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 dividing value by 100...
 

You could try

tools|Options|Edit
un-check fixed decimal places

Mike

"Irfan Khan" wrote:

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 dividing value by 100...
 

Another possibility is that you have custom formatting turned on for
that cell. Go to Format- Cells and just click on the number format

On Jan 11, 6:57 am, Irfan Khan
wrote:
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