Parentheses for negative numbers in Excel 2011

I couldn't find an appropriate section for this question. Please forgive me if I posted it in the wrong place.

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!

iMac, Mac OS X (10.7.3), 2.7GHz Quad, Core I5, 2x4GB

Posted on Oct 22, 2014 4:13 AM

65 replies

tbirdvet

Level 6

17,090 points

Feb 8, 2016 4:44 PM in response to curious88

Perhaps you need the update and also El Capitan to work.

jmgathg

Level 1

9 points

Mar 15, 2016 4:23 AM in response to gsusser

This issue is FIXED!

I didn't notice which update from Microsoft Office fixed the issue but now, by default, the negative brackets are back when using comma or accounting formatting.

Thank you Microsoft!

tbirdvet

Level 6

17,090 points

Mar 18, 2016 5:08 PM in response to jmgathg

Which version of Office and which OSX are you using?

Mar 19, 2016 4:59 AM in response to tbirdvet

Office 2011 and OS X 10.11.3 fixed the issue for me.

jmgathg

Level 1

9 points

Mar 19, 2016 5:39 AM in response to tbirdvet

OSX 10.11.3

Office version 14.6.1 (160122)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Parentheses for negative numbers in Excel 2011