Bring back parentheses in Accounting number format
Bring back parentheses for negatives in Accounting number format. These were lost in Excel Mac 2011. They're a common standard.
This has been fixed for a while now, and the root cause was actually a change in OS X’s handling of number formats. If you update to OS X version 10.11 or higher, and a sufficiently recent version of Excel 2016 for Mac (15.10 or higher) you will see these restored.
Julie – if you are unable to update your OS or version of Excel, you should be able to use the following custom format code to add parentheses to for negative formatting.
I change my windows Region system but Excel 10 not apply this type xx,xx,xx,***.00 grouping
This is a problem with the computer settings... happens every time I get a new computer. Here's the fix:
Representing negative values with brackets in Windows 7
Negative values display with minus signs rather than with with brackets. How can I change the minus signs to brackets in Working Papers?
Follow the steps below:
1.Close Working Papers.
2.Click on the Windows Start button and select Control Panel.
3.In the Control Panel click Clock, Language and Region.
4.In the Region and Language section, click Change the date, time, or number format.
5.In the Region and Language dialog, click the Additional settings button.
6.In the Customize Format dialog click the Currency tab.
7.On the Currency tab, select ($1.1) from the Negative currency format dropdown list (and do this for just negative numbers as well).
8.Click OK in the Customize Format dialog.
9.Click OK in the Region and Language dialog.
10.Close the Control Panel.
KEVIN ULIASSI commented
STILL NOT FIXED! CAN I GET MY MONEY BACK ON COMPUTER UNTIL IT IS?
My problem now is that, with the latest update to Excel 2011 version 14.6.9 the program no longer inserts commas between 000's - even thought there is still a button on the number formatting screen to do so. I tried a custom format but that won't work either. I am running El Cap 10.11.6
Is there no support/fix for earlier versions of excel?
Thanks for the fix on the custom format. I am not upgrading at this time from Yosemite to El Capitan, so the custom formatting works in the meantime.
James Spotanski (Microsoft Excel) commented
This has been fixed for a while now, and the root cause was actually a change in OS X's handling of number formats. If you update to OS X version 10.11 or higher, and a sufficiently recent version of Excel 2016 for Mac (15.10 or higher) you will see these restored.
Julie - if you are unable to update your OS or version of Excel, you should be able to use the following custom format code to add parentheses to for negative formatting.
I wish I could add more votes to this. This is a basic formatting item that should be available. Please, please, please update this formatting so that parenthesis are available as a format under any format, not just the Accounting format. I can't even build a custom format to use the parentheses.
This is a huge issue for accounting practice - this is much easier to read with the parethesis than with the negative sign and should be a basic standard.
Count't agree more
Couldn't agree more. We accountants use visual cues. This is a serious error in judgment by Microsoft.
This issue really needs to be resolved. It's ridiculous that such a standard tool has been removed and has been unresolved for so long.
PLEASE this is an issue for all accountants, brackets and/or red formatting is so much easier to read in large spreadsheets!!!!!!
Bob Jones, AKA Cybertaz commented
Sorry, Jim, but I beg to differ :-) I couldn't resist because it's taken way too long to resolve...
For one thing, I'm not so sure you can lay the blame on Yosemite... Excel 2008 running on Yosemite (same Mac, in fact) provides parenthetical negatives for Number, Currency & Accounting formats. Why can't 2011 & 2016?
For another, even if the problem was Yosemite, El Capitan is in its 3rd iteration (10.11.2) & the parenthetical negatives apparently still are missing.
Third, if it's a Yosemite problem, how can other programs - even Apple's Numbers - running on that version of OS X provide parenthetical negatives (bot Red & Black), but a powerhouse like Excel can't get it restored?
Problem still exists (Oct22.2015) and I am using 10.11.1 El Capitan and 14.5.6 (150930) Excel for Mac 2011.
James Spotanski (Microsoft Excel) commented
This is a problem related to OS X 10.10 Yosemite. You should see the options for parenthetical negative values restored in OS X 10.11 El Capitan which will be available for public download from Apple on September 30.
Thanks for your feedback!
It's been 11 months, and this still isn't fixed.