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