=IF(A1="","",A1)
--
David Biddulph

"Bookworm" wrote in message
oups.com...
I am linking some Text cells in a worksheet to other cells to
automaticaly link them with Copy/Paste Link.

Even though the source cell is formatted as text the target cell shows
a zero (0) when empty. How do I get the target cell to stay blank?