Hi
Is there a way to format cells containing numbers so that they will be excluded from a SUM (or any other formula), in other words, render their value zero.
I tried format as text, it did not work, it just left aligned the number.

excel 2002
thanks