Parantheses for negative numbers in Excel 2011

[gsusser]

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!

 

[QWERTYMac7]

You might try 'Custom' and look for a format like this:

(#,###)

 

[jkarol3]

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!

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