Forum Discussion

cassandraann1's avatar
cassandraann1
Copper Contributor
Jan 26, 2019

Inconsistent Formatting in Cells with Formulas that Equal Zero

I have a spreadsheet with three columns of numbers. Then there are two additional columns that contain simple subtraction formulas. The solution of all the formulas is zero, yet the cells do not display zero consistently. I have checked that the format settings are consistent across the entire spreadsheet, and have double checked by painting the format settings down the entire spreadsheet.  But still, the first half of the rows display "zero" as a dash and the second half of the rows display "zero" as 0.00 and (0.00). All of the numbers have only two digits after the decimal point. I don't know what else to attempt to fix this, but it is driving me crazy.

 

 

 

Inconsistent formatting of zero

I have a spreadsheet with three columns of numbers. Then there are two additional columns that contain formulas. The solution of all the formulas is zero, yet the cells do not display zero consistently. I have checked that the formatting settings are consistent across the entire spreadsheet, and have double checked by painting the format settings down the entire spreadsheet.  But still, the first half of the rows display "zero" as a dash and the second half of the rows display "zero" as 0.00 and (0.00). All of the numbers have only two digits after the decimal point.

Resources