| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? | Excel Discussion (Misc queries) | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
