Linked cell value showing 0 if empty

How can i change a linked cell with no value to show up as a empty cell instead of having a zero in there all the time?

Thanx

Hi,

You could try

Tools > options > Window options then untick Zero Values

or usa an if statement

=IF(Sheet1!A1=0,"",(Sheet1!A1))


VBA Noob