On 10 Aug, 14:15, Tim879 wrote:
You could also use the isblank function

=if(isblank(a1),"",a1)

On Aug 10, 6:10 am, Bookworm wrote:

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?

Thanks for info. A question though? you suggest: =if(isblank(a1) etc
what cell does this refer to? where the source is? and at the end you
use the same cell reference a1 what does this refer to and where do I
place the formula in the source worksheet or the target worksheet.
Sorry for seeming an idiot but I am fairly new to anything but the
simplist spreadsheets.