Thread: Why does 100 turn into 1 when I enter it into a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default Why does 100 turn into 1 when I enter it into a cell?
Check your format to see if it is set to percent for that cell or range of
cells.

"Ashley Luo" wrote:

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