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?

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?

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?

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?