To Hide entries that only contain 0, you can use the cell formatting. Go to
Format Cells and chose "Custom" under the category. This will get you a
collection of base formatting. Notice that some of the numeric formats
include a semicolon (and some contain two). The semi colons divide the
format into two or three possible formats. The first one is for positive
numbers and the second one is for negative numbers. The optional third one
is for the value zero.

So choose a format and either add the second semicolon or remove the
formatting after the second semicolon. For example, #,##0;[Red]-#,##0; will
colour negative numbers red and hide zero values.



You can get creative and put something like "zero" in the third position.
(Remember to add the quotes.)