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!
