MJ

You are doing nothing wrong. Excel does that for you.

Either turn off zeros through ToolsOptionsView or.........

Enter a formula in your linked cells that change the values to blank.

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


Gord Dibben Excel MVP

On Thu, 28 Jul 2005 15:30:02 -0700, "MJ" wrote:

When linking data within the same workbook (to different tabs) any cell that
is empty - shows up in the new tab as a ZERO (0).....what am I doing wrong? I
want those cells to remain blank.