Forum Discussion
Brackets around negative numbers (formatting)
I am trying to get to grips with the basics of excel at the moment and just trying to sort out some optimal settings. In finance I think its standard for negative numbers to be in brackets i...
You may change Windows regional settings as here Negative numbers aren't showing with parentheses in Excel - Microsoft Support
Alternatively apply first negative numbers with Red format. Select cells again, Ctrl+1->Number->Custom
and here change text after semicolon on
You may remove [Red] if prefer default color.
Detlef_Lewin I have just tried both and both show a minus sign but no brackets
