Forum Discussion
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 fo...
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).
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
It's best to use the same number format for all cells in a column. If you mix formats, anomalies are bound to happen...