Unable to format negative values in excel using parentheses

Question

I recently lost the ability to format negative values in excel using parentheses. (format setting:  number, currency, etc)

After doing some research, it appeared that this might be due to the "region" settings of my computer, but I verified that it is set to US.

I recently upgraded to Yosemite and believe this is related to the issue.

anyone have any guidance to fix this issue?

thanks

Answer 1

Highly disappointing that this problem remains an issue in Office Preview for Mac.

Answer 2

Custom number formatting still works.  I use that a lot anyhow.  

https://support.office.com/en-za/article/Create-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4?ui=en-US&rs=en-ZA&ad=ZA

Answer 3

Thought this would be interesting for you to know Just for curiosity I formatted a Currency number in Excel(Preview)2016 This s what it looks like now.

Appears as though the Parenthesis is gone for good. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.

Answer 4

This problem has not been addressed by Microsoft. The new Office 365, which includes Office 2016, is still unable to format a negative number by enclosing in parentheses (using Accounting number format). If you check the actual script in the number dialog box, you'll find "-" where there should be "(" and ")".

Answer 5

This format works...