Thread: Why does 100 turn into 1 when I enter it into a cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashley Luo Ashley Luo is offline
external usenet poster
  
Posts: 1
Default Why does 100 turn into 1 when I enter it into a cell?
I typed the number 100 in a cell and it automatically turned into 1.
Similarily, when I typed the number 1, it automatically turned into 0.01.
Excel is dividing every number I type by 100. Does anyone know why that is
and how I can fix it?
Reply With QuoteReply With Quote