Tom’s Tutorials For Excel: Hiding Zeroes in Cells
Here’s a way to hide zeroes in cells, to improve the readability of your spreadsheet by making only the relevant non-zero numeric values visible.
Select the range of interest, right-click on that selection, and left-click to select Format Cells.
In the Format Cells dialog box:
• Select the Number tab.
• In the Category list, select Custom.
• In the Type field, enter
#;-#;; (notice the semicolon separators).
• Click OK.