How to get a number show up as 0 inside a formula.

Originally Posted by Beamernsw

I think what you want is "--" instead of just -- to display it as text, or just "" to leave the cell blank

=IFERROR(yourformulahere,"--")

Ya that's what I have already.