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?