View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jag
 
Posts: n/a
Default Enter 1 in a cell, excel change to 0.001, WHY?

In the excel spread sheet.
when ever I enter any number it gets divided by 1000 on its own.
say if i enter 1 excel convert it to 0.001
i tried format cell option but could not correct it,
does any one know WHY?