Adding Display Zero as Dashes to Custom Excel Number Format

[emmagreen]

Hi There,

I am currently using the following custom format cells for my number display:

#,###.0,;[Red](#.0,);

I would like to add to this, so that when a value is "0", a dash "-" is displayed instead of the zero.

Thanks in advance for the help!

Emma

[#2]

Hi Emma,

Please check out this link.

As described in the link, you can use the below custom format to do so.

_(* #,##0_);_(*(#,##0);_(* “-”??_);_(@_)

But you can modify it as follows to show a dash only without surround it in double quotes:

_(* #,##0_);_(*(#,##0);_(* -??_);_(@_)

Hope that helps