Paste Link enters a 0 into the cell where I paste. How do I elemin

[Guest]

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.

 

[Guest]

Tools -> Options -> View

Uncheck the box next to Zero Values

 

[Dave Peterson]

It won't be null, but it'll look blank:

=if(a1="","",a1)

Or between sheets:

=if('sheet 1'!a1="","",'sheet 1'!a1)

 

[Guest]

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.

 

[Dave Peterson]

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