zeros

[Guest]

Hi
I have several fields that are linked to a worksheet in another file. The
cell in the other worksheet is blank, but puts a zero in the current
worksheet. I have tried formatting (does'nt work) , I have tried options and
cleared the zero check box. Any suggestions about what I could do to get rid
of the zeros would be a BIG help.

 

[Guest]

Instead of using something like:
=Sheet1!A1
use:
=IF(Sheet1!A1=0,"",Sheet1!A1)

 

[Dave Peterson]

You can add a check:
=IF([book2.xls]Sheet1!$A$1="","",[book2.xls]Sheet1!$A$1)