Paste link
 

I currently have Excel 2003 and I am attempting to paste link. The cell I'm
copying is blank but when I paste link the cell I paste on comes up 0. This
is screwing up my figures as these are all for formulas. How can I paste
link and have the cell be blank as well. Thank you for your help in advance.

Paste link
 

Hi erin

ToolsOptions

On the View tab you can turn of "zeros values"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Erin Leva" wrote in message ...
I currently have Excel 2003 and I am attempting to paste link. The cell I'm
copying is blank but when I paste link the cell I paste on comes up 0. This
is screwing up my figures as these are all for formulas. How can I paste
link and have the cell be blank as well. Thank you for your help in advance.

Paste link
 

Let's say that the Paste Link formula is =Sheet1!$A$1 which is calculating to
0 because A1 on Sheet 1 is blank. Replace =Sheet1!$A$1 with
=IF(Sheet1!$A$1="","",Sheet1!$A$1)

"Erin Leva" wrote:

I currently have Excel 2003 and I am attempting to paste link. The cell I'm
copying is blank but when I paste link the cell I paste on comes up 0. This
is screwing up my figures as these are all for formulas. How can I paste
link and have the cell be blank as well. Thank you for your help in advance.