View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default 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