In excel when I type =100 into a cell the number 100 appears in that cell as expected. But if I just type 100 it shows 1 which is not expected. It divides any number I enter by 100 in all cells. However if I type 1,000 then 1000 comes up (1000 gives 10). Any ideas what's happening here?