Forum Discussion
Solved
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.
Thanks for the illustration of already mentioned link https://support.microsoft.com/en-us/office/negative-numbers-aren-t-showing-with-parentheses-in-excel-682a1cc5-701a-4ce7-92db-cc9eebc5ffa0
Thank you. Works. Problem solved.
Obieey , you are welcome