Forum Discussion
james655
Apr 11, 2021Copper Contributor
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 format for this?
Also how do I show negative numbers in red?
Thanks for your help.