Forum Discussion
Number format for zero value
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 ...
Use this custom format:
#,##0" ";[Red]"-"#,##0" ";
The ; at the end suppresses the display of zero values.
