Red1014 wrote:
I have already gone to tools and options and hidden all zero values, but I
still have about six cells that have formulas in that are showing the zeros.
Are there any other things that can be done to hide these few zeros that
insist on hanging on?

Are the results of the formulae generating decimals e.g. 0.23 and then
being formatted to show no decimal places (this would appear in your
sheet as a zero), excel will still show these values as they are not
actually zero.