| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
zero's in linked cells
I'm putting together a workbook for logging criminal offenders and victims.
I have columns linked on multiple worksheets. I don't know how many entries will be on each worksheet, so the entire column must be linked. Because the entire columns are linked to columns that are not yet filled in, I have infinite columns of 0's. Is it possible to get rid of the 0's in the linked columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zero's in linked cells
I assume you have a formula to link them..
assuming this, and starting in, say, cell A2: if(formula = 0,"", formula) replace "formula" with your formula... "luckeyme" wrote: I'm putting together a workbook for logging criminal offenders and victims. I have columns linked on multiple worksheets. I don't know how many entries will be on each worksheet, so the entire column must be linked. Because the entire columns are linked to columns that are not yet filled in, I have infinite columns of 0's. Is it possible to get rid of the 0's in the linked columns? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zero's in linked cells
Sean Timmons
You could goto ToolsOptionsviewand remove the check mark on "Zero Values". Mike Rogers "Sean Timmons" wrote: I assume you have a formula to link them.. assuming this, and starting in, say, cell A2: if(formula = 0,"", formula) replace "formula" with your formula... "luckeyme" wrote: I'm putting together a workbook for logging criminal offenders and victims. I have columns linked on multiple worksheets. I don't know how many entries will be on each worksheet, so the entire column must be linked. Because the entire columns are linked to columns that are not yet filled in, I have infinite columns of 0's. Is it possible to get rid of the 0's in the linked columns? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zero's in linked cells
Hi
Toolsoptionsviewuntick zero values -- Regards Roger Govier "luckeyme" wrote in message ... I'm putting together a workbook for logging criminal offenders and victims. I have columns linked on multiple worksheets. I don't know how many entries will be on each worksheet, so the entire column must be linked. Because the entire columns are linked to columns that are not yet filled in, I have infinite columns of 0's. Is it possible to get rid of the 0's in the linked columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
Hybrid Mode
