Copying Worksheet Cells Getting 0's

[Guest]

I have a summary sheet which has cells that links to a number of worksheets
in a workbook. When I link to a blank cell in a worksheet I get a 0 on the
summary sheet. I would prefer that the summary sheet be a blank entry also.

Does anyone know why this occurs and is there a way to get rid of it.

Thanks,

 

[Gord Dibben]

=IF(Sheet1!A1="","",Sheet1!A1)

OR...Tools>Options>View. Uncheck "zero values" which I find rather drastic.


Gord Dibben MS Excel MVP

 

[Guest]

hi,
you can use the formula "=IF(B1>0,B1,"")" in the summery sheet to avoid "0"
instead you will get a blank space.