View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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?