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