Forum Discussion

emmagreen's avatar
emmagreen
Copper Contributor
Jan 22, 2019

Adding Display Zero as Dashes to Custom Excel Number Format

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

excel
Formatting
numbers

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jan 22, 2019

    Hi Emma,

     

    Please check out this https://www.exceltip.com/excel-format/replacing-zeros-with-dashes-in-number-formatting.html.

    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

Resources