Forum Discussion
HolySachet
Nov 04, 2020Copper Contributor
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...
J_E-P
Jun 29, 2021Copper 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
HansVogelaar
Jun 29, 2021MVP
It's best to use the same number format for all cells in a column. If you mix formats, anomalies are bound to happen...