Home

Parentheses

kent97038
Occasional Visitor

I have a spread sheet and sometimes the number in a column is negative. How can I have those numbers auto with parentheses? Also I have seen color dots green for positive and red for negative.

1 Reply

You shall apply custom number format, e.g. like 

#,##0.00_ ;[Red](#,##0.00) 

Please check https://exceljet.net/custom-number-formats for more details

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies