A little more info on this issue.....

the data in colum AO that has zeros is displayed as "0". Once I click in the cell, then in the formula bar, then out again, the value changes to "0.00", and the value in column AX (where the formula is) gets updated accordingly........what is going on here?