Mar 27 2021 08:38 AM
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!
Mar 27 2021 08:56 AM
See your other topic https://techcommunity.microsoft.com/t5/excel/cell-formatting-problem/m-p/2239550