If the cells contain formulas, one cell may return a value that's very
small, e.g. .00000000001

This would display as zero in the cell, due to rounding. The cells that
actually contain zero show a dash.

SundanceKidLudwig wrote:
I have formatted cells with the accounting format with no symbol. Two cells
that compute to zero show differently. One shows 0.00 and the other shows a
"-" dash. I have rechecked all of the cells that are included in the formula
for each and I cannot find any inconsistencies; all are formatted the same.
I realize that this seems petty but for the life of me I cannot determine why
the same formatting shows two different designations for zero. I prefer the
"-" dash.

Can anyone suggest what I can look at to try and resolve this?

Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html