cell formatting problem

New Contributor

Why does the cell show a zero when adjacent cells show a dash? The cell formatting is set the same:

_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_) Custom fomatting

The formula is =D14+D18+D23 in one cell and results in a zero

The formula is copied across and the adjacent cells are dashes.

When I changed the row to all general number formatting, the cells with a zero show:

2.91038E-10  What is that??? Help!

1 Reply