D
Don Rountree
I have a worksheet with the cells in column J formatted as Accounting with decimal places set to 2. The numbers in column J are dollar figures and are not fractions of cents. The column contains amounts of invoices and also the collections of these invoices. In essence, one should cancel the other, leaving a zero balance. The problem is this. In column K I have a formula that uses the SumIf function to total the numbers by invoice number. Some of the results show as "-" which is zero when cells are formatted as "Accounting". However, there are numbers in the same column that show as "0.00", but the cell is formatted as "Accounting" as well. Can anyone tell me why this occurs? Thanks in advance.