Apr 11 2021 03:22 AM
Hi.
I am using the following number format for a cell: #,##0" ";"-"#,##0" "
But if the value in the cell is zero I want to display a blank cell and not "0" or a "-".
How do I construct the number format for this?
Also how do I show negative numbers in red?
Thanks for your help.
Apr 11 2021 03:50 AM
Use this custom format:
#,##0" ";[Red]"-"#,##0" ";
The ; at the end suppresses the display of zero values.