I have a spreadsheet with 4 columns; the 4th columns is a formula going
across the 3 columns a+b-c = d with d preferably equally zero. When I format
column d almost all of the columns that equal zero display as a dash
(preference). However periodically one or two of the rows will display as
0.00 and I can't seem to get the formatting to change to the dash. I have
tried to reformat all columns all other cells and to no avail. Has anyone
else run into this issue and if so how have u solved it. The only way I can
solve it is to actually put a zero in the cell.