Parantheses for negative numbers in Excel 2011

Discussion in 'Mac Apps and Mac App Store' started by gsusser, Oct 22, 2014.

  1. gsusser macrumors regular

    Joined:
    Jun 20, 2012
    Location:
    jersey city
    #1
    I've been using Excel for Mac 2011 since it came out. Up until I updated to Yosemite, formatting negative numbers with parentheses appeared in the drop down menu, i.e., right click to get format cells, click "number" tab on top, click "number" on left. There is a dialog as to how you want negative numbers formatted. Parentheses used to be an option but no more. I attached a screen shot. Help!
     

    Attached Files:

  2. QWERTYMac7 macrumors regular

    Joined:
    Nov 20, 2012
    #2
    You might try 'Custom' and look for a format like this:

    (#,###)
     
  3. jkarol3 macrumors newbie

    Joined:
    Apr 17, 2008
    #3
    You will need to use "custom" and use 0_);[red](0)
     

Share This Page