zeros

M

mac

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.
 
G

Gary''s Student

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

Dave Peterson

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