Whole number minus whole number = decimal number?

    Hi there,


    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.


    Thanks,
    Kieran

    Re: Whole number minus whole number = decimal number?


    This might be due to Excel's floating-point arithmetic or your original entries (if result from a formula) also contain many decimal places.


    You could use ROUND() to 2 decimals in your formula.


    e.g.


    [COLOR="#0000FF"]=ROUND(A2-B2,2)[/COLOR]


    where A2 and B2 contain the originals.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login