That's just the way it is ..

Instead of : =Sheet2!A1
you could use an error trap: =IF(Sheet2!A1="","",Sheet2!A1)

Alternatively, we could suppress the display of extraneous zeros
in the entire sheet via:
Click Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"MJ" wrote in message
...
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.