Forum Discussion

james655's avatar
james655
Copper Contributor
Apr 11, 2021

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.

Resources