To do such a large area, it might be quicker to highlight all the
cells with this formula in and apply Format | Conditional Format.
Select "Cell Contents" and then 0 (zero), then click the Format button
and choose a foreground colour of white - click OK to get out of this.
Now wherever you had zero you will see a blank cell (the zero is still
there, it's just printed white on white so you can't see it).

Hope this helps.

Pete

On Feb 9, 4:01 pm, Kathy wrote:
I have the same problem, but I'm linking an entire worksheet, not just a
single cell and therefore everything that doesn't have a value comes up -0-.
Any way to paste a link without getting all the -0-s



"Gary''s Student" wrote:
In place of the usual:
=A1
use:
=IF(A1="","",A1)
--
Gary's Student

"Barry FL" wrote:

When I link a worksheet to another worksheet to use the values, if there is
no value in the primary worksheet than a 0 is shown in that cell on the new
worksheet. is there a way to hide the 0 until a value is entered in the
primary worksheet. - Hide quoted text -

- Show quoted text -