Jan 22 2019 09:42 AM
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
Jan 22 2019 10:58 AM - edited Jan 22 2019 10:58 AM
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