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.

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.

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.