Excel 2011 does not accept ^ for exponents?

Discussion in 'Mac Apps and Mac App Store' started by adityanag, Oct 23, 2010.

  1. adityanag macrumors newbie

    Joined:
    Oct 28, 2009
    #1
    Hi,

    When I try a formula like =2ˆ3 in Excel 2011, it throws up an error. Excel 2011 doesn't accept ^ for the exponent????
     
  2. Bkxmnr macrumors regular

    Bkxmnr

    Joined:
    Feb 9, 2009
    Location:
    Wichita, KS
  3. silentsim macrumors regular

    Joined:
    Jul 9, 2010
    #3
    It does for me.
    =2^3

    Cell returns 8

    However when copy pasting your =2ˆ3 it returns an error. Are you using shift+6 :p
     
  4. adityanag thread starter macrumors newbie

    Joined:
    Oct 28, 2009
    #4
    I figured it out

    My keyboard was set to US-International. Setting it to US extended fixed it. Apparently the ^ is different in the two keyboard layouts.
     

Share This Page