When I copy column A and do a 'Paste Link' into column B, any blank cells in column A are converted to a '0' in column B. I've tried everything to prevent this from happening, with no joy.

Any ideas?