I'm currently facing an error where all zero values should automatically revert to a "-". This is working fine for all cells, however I'm having an error with one in particular. Currently the value in E17 is 8,769.60 and the value in E34 is 8,769.60. There are no more decimals after these figures. When I do one less the other, excel returns a value of "0.00". When I expand this value, it shows up 0.0000000014897523215.
Is there any way to stop this from happening? I have tried formatting the cells, putting in the values manually etc. but I still get the same problem.