And if you don't have any other cells that evaluate to 0 on that worksheet that
you want to see (or just constant 0's, too).



Brett wrote:

Maybe a simpler way is to apply the custom number format: General;-General;
This format will display whatever the cell is linked to as long as the cell
it links to does not contain a zero. So if the cells you are linking to never
contain a zero this will work, otherwise the "0" will be invisable.

"UNR" wrote:

When I use Paste Link the cell that I link to shows a 0 iin the cell if there
is no data in the cell it is linked to. How do I eleminate the 0. I want the
cell to be null if there is no data.

--

Dave Peterson