Copying Worksheet Cells Getting 0's
 

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,

Copying Worksheet Cells Getting 0's
 

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

OR...ToolsOptionsView. Uncheck "zero values" which I find rather drastic.


Gord Dibben MS Excel MVP

On Wed, 4 Oct 2006 15:55:02 -0700, Lee wrote:

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,

Copying Worksheet Cells Getting 0's
 

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


"Lee" wrote:

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,