Number format for zero value

[james655]

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.

[#2]

@james655 

Use this custom format:

#,##0" ";[Red]"-"#,##0" ";

The ; at the end suppresses the display of zero values.

[#3]

@Hans Vogelaar 

It works! Thanks so much