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...
twhiteley
Jun 27, 2024Copper 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]* "-"??_ ;_-@_