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

    Jun 20, 2012
    jersey city
    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

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

  3. jkarol3 macrumors newbie

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

Share This Page