Number format for zero value

%3CLINGO-SUB%20id%3D%22lingo-sub-2266383%22%20slang%3D%22en-US%22%3ENumber%20format%20for%20zero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266383%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3EI%20am%20using%20the%20following%20number%20format%20for%20a%20cell%3A%20%23%2C%23%230%22%20%22%3B%22-%22%23%2C%23%230%22%20%22%3C%2FP%3E%3CP%3EBut%20if%20the%20value%20in%20the%20cell%20is%20zero%20I%20want%20to%20display%20a%20blank%20cell%20and%20not%20%220%22%20or%20a%20%22-%22.%3C%2FP%3E%3CP%3EHow%20do%20I%20construct%20the%20number%20format%20for%3CSPAN%3E%26nbsp%3Bthis%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAlso%20how%20do%20I%20show%20negative%20numbers%20in%20red%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20for%20your%20help.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2266383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies

@james655 

Use this custom format:

 

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

 

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

@Hans Vogelaar 

 

It works! Thanks so much