Forum Discussion
zero values to dashes
Excel displays a dash for zero value in all but two cells when formula is copied across row. The custom cell formatting is set to _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_) The formula copied across ...
That's rounding error, you may use something like =ROUND(C14+C18+C23,2) instead.