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

[HolySachet]

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

[#2]

@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).

 

[#3]

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

[#4]

@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...