Unable to format negative values in excel using parentheses

Anonymous
2014-10-20T14:09:36+00:00

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

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

20 answers

Sort by: Most helpful
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2014-11-08T17:37:01+00:00

    There currently is no fix for this problem. If you are affected please send a suggestion to Microsoft asking that they fix this. To display the suggestion form, go to Excel's Help menu and choose the Send Feedback option. The more suggestions, the more likely it is the problem will receive prompt attention.

    0 comments No comments
  2. Anonymous
    2014-11-08T17:51:33+00:00

    Jim:  thanks for staying with this issue.  I will send a suggestion to Microsoft.  One question though; is this a fix that Microsoft can make or does  it have to come form Apple?

    0 comments No comments
  3. Bob Jones AKA CyberTaz MVP 430.3K Reputation points
    2014-11-08T19:11:06+00:00

    We have no way of knowing... All we are sure of is that the issue has been reported only by those using Yosemite. The same version of Excel works fine with all other versions of OS X & several users have even confirmed that they had no problem on the same Mac before converting to Yosemite.

    0 comments No comments
  4. Anonymous
    2014-11-12T17:16:17+00:00

    Anyone know when this will be fixed?  There was an update, but the issue still isn't fixed on my end.

    0 comments No comments
  5. Jim G 134K Reputation points MVP Volunteer Moderator
    2014-11-12T17:55:37+00:00

    Only someone at Microsoft working on Excel would know when there will be a fix. None of us here work at Microsoft, so all we can do is watch and wait.

    0 comments No comments