Excel for Mac 2008 Formula Display Issue

Discussion in 'Mac Apps and Mac App Store' started by macbookprointn, Jul 2, 2008.

  1. macbookprointn macrumors newbie

    Joined:
    Jul 2, 2008
    Location:
    Nashville, TN
    #1
    Hi,

    I have been using Excel 2008 without incident until yesterday when it now shows formulas in the formula window in what seems like nonsensical characters. An example of one simple formula to just subtract two cells in a sheet shows the following instead of the normal formula one would expect with column and row numbers/letters:
    =R[-4]C-R[-2]C

    I may have done something that I don't realize but I would consider myself an advanced Excel user and have never seen this before. Any help someone from the Mac SBU or otherwise would be much appreciated to clarify what I can do to fix this issue. Thanks.
     
  2. NAG macrumors 68030

    NAG

    Joined:
    Aug 6, 2003
    Location:
    /usr/local/apps/nag
    #2
    Did you hit the ANOVA stat function or something?
     
  3. Raid macrumors 68020

    Raid

    Joined:
    Feb 18, 2003
    Location:
    Toronto
    #3
    The formula view you are seeing is a different way of defining a cell range. For example instead of cell references looking like "A1" you'd probably see "R1C1" (R=row, C=column) in the example you have it looks like it's referencing a cell four rows up (and in the same column) minus the cell two rows up (and in the same column)

    You probably accidently changed the formula preferences in the Tools>Options submenu. Look for "R1C1 Reference Style" in the General tab and uncheck it.
     
  4. macbookprointn thread starter macrumors newbie

    Joined:
    Jul 2, 2008
    Location:
    Nashville, TN
    #4
    Thanks - that was the issue

    This was the problem - not sure how it got triggered. Thank you and all the replies for the help.

     

Share This Page