Excel weird behaviour

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

  1. williamsardar macrumors newbie

    Joined:
    May 3, 2008
    #1
    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

    Joined:
    Jun 13, 2008
    #2
    Percentage?

    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