global formula for entire worksheet? override any cell that has "0" replace with blank value

Copper Contributor

I have a comprehensive summary worksheet that pulls various cell data from another worksheet. However, if the referencing worksheet has a null value, excel will pull it forward as a zero (0) value upon display. Rather than have a relative formula to each cell, is there a way to override any field (one time, globally) containing zero and replace it with a true blank/null value? 

1 Reply
best response confirmed by domdel (Copper Contributor)