Could you use conditional formatting to turn the font to white? or do
you need the zero to vanish completely?

Hi go to format cells, custom and use #,##? and it will get rid of
the 0's and leave the rest of the number.

Here is the way I would do it.
I take your problem as wanting to delete the value in the zero cells and not
the cell or the row.

Sub DeleteZeros()
'Preset starting point
StartColumn = 1 'A
StartRow = 1
'get last entry
EndOfFile = Cells(Rows.Count, StartColumn).End(xlUp).Row + 1
'Delete Zeros
While StartRow < EndOfFile
If Cells(StartRow, StartColumn).Value = 0 Then Cells(StartRow,
StartColumn).Value = Empty
StartRow = StartRow + 1
Wend
End Sub

Replace has a "match entire cell contents" option. I think that's what you
need.

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.)