Forum Discussion
Brackets around negative numbers (formatting)
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.
Just open Control Panel and click on "Change date, time or number formats" (highlighted in image attached) > Additional Settings > under Numbers tab in front of Negative numbers format choose bracket number using drop down menu.
Similarly do this under currency tab in front of negative currency format.
I've attached images to better understand and resolve the issue PERMANENTLY.
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
