How to display a dash instead of a zero in excel | How to return dash for 0 in Excel

How to display a dash instead of a zero in #excel | How to return dash for 0 in Excel

To display a dash instead of the number 0; Select the range and right click by mouse and click on format cells then go to custom under Number Tab and type #;#;- and click ok. its done.

[NNk-di]

Wao problem solved. Before we used to turn zero into dash manually

[akshigowda]

Nice but decimal gets roundoff what to do for that??

[rashijain]

If values are in percentage then? Like instead of 0, its 0%

[fitbaw]

what if I want commas to separate the thousands too?