Thanks! I actually found this in Excel Help and think it's a bit simpler:

Use a number format to hide zero values in selected cells
Caution Follow this procedure to hide zero values in selected cells. If the
value in one of these cells changes to a nonzero value, the format of the
value will be similar to the general number format.

Select the cells that contain the zero (0) values that you want to hide.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, type 0;-0;;@


"gjcase" wrote:


One way is to use an IF statement rather than a straight link.

Insert =IF(Sheet1!A1="","",Sheet1!A1) in cell A1 of both Sheets 2 & 3
and then copy them across the entire range. This will make all blank
cells on Sheet 1 appear blank on Sheets 2 & 3 and should still work
okay with filters & sums.

Not sure if there's a way to do this by formatting 0s to be blanks,
perhaps someone else can address that?

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528152