Excel 2min Tip #9. How to replace zeroes with dashes. By David Carter
If your spreadsheet contains a lot of zero (0) values, it will be easier to read if you change them to dashes
To display zeroes as dashes:
Go into Format – Custom, and add ;-; (semicolon – dash – semicolon)
Either open or create a worksheet that contains some zeroes (0).
Highlight the numbers.