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.
Fantastic thank you very much the root of the issue was sorted by your first link, don't know that even effected excel. I will keep the custom stuff in mind as well though ! thanks again
Harry_S_S , you are welcome