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.
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.
In custom the bracket formula is not available and I have gone to clock setting and changed to ( ). changing negative numbers to brackets is not available under any of the categories in the home>number tab
Sorry, I didn't catch. We have pre-defined number formats which depend on regional settings. And we have custom number format which we construct ourselves.
Yes, red and brackets are not predefined, but it's not necessary to add such format in regional settings as default one. We may use custom number format like
I do not have any options to select any type that shows (#,0.00 ) or anything with brackets even in the custom settings. My clock is set to show negative as brackets. Where else would I find that formula to add to my excel or what else can I try?
- 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
