Excel weird behaviour

Discussion in 'Mac Apps and Mac App Store' started by williamsardar, May 3, 2008.

  1. williamsardar macrumors newbie

    May 3, 2008
    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?
  2. TheSteveW macrumors newbie

    Jun 13, 2008

    Seems odd. If it wasn't for the fact that the 100 shows as 100 I might guess the cells are formatted to show numbers as percentages - but then you'd see the % sign so....?

    This is a little old so hopefully you've found a fix but if not I'd start with trashing the workbook and starting from scratch. If you've got a lot of data you want to save cut and paste into the new workbook...

Share This Page