If you want the cell to show blank or empty, amend the current formula in the cell with this;
A1 will be the reference cell from which the cell you are concerned with gets it 0.
So, if A1 =0, then fill this cell with an empty text string, (which is what the two quote marks do).
Otherwise, (then the remaining existing formula). Don't forget the final round bracket at the end of the IF statement.
Do that for each cell where this happens or may happen.
I have a mail mearge from excel to Word and all the blank cells are coming through as 0's. How do I keep them blank or empty?
Preferably with field codes and work arounds, I don't have the ability to use VB at work.