Feb 10 2019 12:25 AM
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.
Feb 10 2019 10:48 AM
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