I need a macro that will search each cell and determine if it has a zero
value in it. If it does, it will replace the zero (or in the case of my
data, 0.00), with a hyphen "-".

Here is an example:

Before

A B C D
1 Item1 $5.00 EACH 2.35
2 Item2 $0.75 EACH 0.50
3 Item3 $0.00 0.00
4 Item4 $2.50 CASE 0.00

After

A B C D
1 Item1 $5.00 EACH 2.35
2 Item2 $0.75 EACH 0.50
3 Item3 - -
4 Item4 $2.50 CASE -

As you can see, if a cell is blank and has no data in it, I don't want a
hyphen in there. Only where the cell has 0.00 in it. Thanks for the help!