Excel Parentheses

Discussion in 'Mac Apps and Mac App Store' started by nikond, May 29, 2009.

  1. nikond macrumors newbie

    Joined:
    Dec 30, 2008
    #1
    When I try to put a parentheses around a number all I get is a negative number. Example: (1) gives me a -1. Anyone have an idea what's wrong?
    Thanks,
    Al
     
  2. akadmon macrumors 68010

    Joined:
    Aug 30, 2006
    Location:
    New England
    #2
    Nothing's wrong. This is standard Excel notation for negative numbers.

    You have two options:

    1. Put an apostrophe, eg., '(1), in front. Problem here is that the cell contents will become text.
    2. Go to Format/Format Cells/Number and select the (1234) format with black text option.
     
  3. scienide09 macrumors 65816

    scienide09

    Joined:
    May 5, 2007
    Location:
    Canada
    #3

Share This Page