You will get a zero if the source cell contains no data.

One way to get around this is use an IF formula in the target cell.

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


Gord Dibben MS Excel MVP

On Thu, 05 Jul 2007 14:58:13 -0700, dzelnio wrote:

When I drag a cel that is linked to another worksheet, it drops a zero
into my target cel. The information in the cel is text, no numbers.

I linked by doing a paste special.

How do I control the drag and drop feature?

dzelnio