Link cell show zero when source cell is blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In worksheet 'Strategy Map,' cell K7 has link formual ='Objective C1'!AV21.

In worksheet 'Objective C1,' cell AV21 is blank; however, K7 holds a zero.

The format for both cells is percent, but even changing them to text does
not change the zero value in K7.

How do I get K7 to be blank?

Thanks, Phil
 
Hi Dave,

Thanks for your answer - it solves the problem. In this "zero" a
characteristic of Excel? Don't remember it coming up before.

Thanks, Phil
 
It's been part of excel for as long as I can remember.

And IIRC, Lotus 123 release 2.4 did it the same way (last version I used).
 
Back
Top