Forum Discussion

HolySachet's avatar
HolySachet
Copper Contributor
Nov 04, 2020

Impossible to have parenthesis for negative numbers (accounting) on Excel 2020 for mac

Hello,

 

Parenthesis for negative numbers are very common in Accounting -123=(123). I am stuck with the minus sign (-) and cannot change the format for parenthesis.

 

When I go on "more number formats", the option is not available, neither in Accounting or in Numbers. I can only turn negative numbers in red color.

 

I have to mention my software and computer is in English but I live in Europe, maybe it has something to do with it?


This is extremely annoying and prevents me to work with Excel for Accounting.

 

Thanks

 

Excel version : 16.42

Operating on : MacOS Catalina 10.15.6

 

 

4 Replies

  • twhiteley's avatar
    twhiteley
    Copper Contributor

    HolySachet 
    Old thread but this custom format seems to fix it and values remain alligned:

    _-[$$-en-US]* #'##0.00_ ;_-[$$-en-US]* (#'##0.00) ;_-[$$-en-US]* "-"??_ ;_-@_



  • HolySachet 

    Does Excel for Mac have Custom in the list of categories?

    If so, select Custom and enter the following in the Type box:

     

    #,##0_);(#,##0)

     

    or

     

    €#,##0.00_);(€#,##0.00)

     

    or similar (if you use comma as decimal separator, switch point and comma in the formatting codes).

     

    • J_E-P's avatar
      J_E-P
      Copper Contributor
      Whilst this works, the numbers is parenthesese (brakets) no longer align well with the number or accounting formatted cells above and below.... any suggestions welcome
      • J_E-P 

        It's best to use the same number format for all cells in a column. If you mix formats, anomalies are bound to happen...

Resources