excel copy and special paste (values) changes the real value

i made cell A1 equal 1.123, cell B1 equal 1.22 and cell C1 is a formula: =A1-B1.
it shows the value 0.001.
then i copied cell C1 and made a special paste (values) in D1.
i expected that the value of D1 would be 0.001 just like C1. but it is different. excel made it 0.00099999999999989.
why did it happen? what can i do to fix it?


Capture1.PNG
Capture2.PNG

This is known as a floating point "error". Others can explain it better than I can. Basically, it has to do with loss of precision while using large or small numbers.

Here is more info on floating point precision:
https://blogs.office.com/en-us/2008/...wrong-answers/

1. i think that the link you sent me is invalid
2. this error happens even if i use 1 digit after the point, for example 1.2 and 1.1

The link works for me. Either way, just search for "floating point error excel" and you can read a lot more about it than I will be able to explain.

It usually doesn't make a difference in your calculations but if it does, you can use =ROUND(A1-B1,4) in place of =A1-B1

i need a good solution to this problem.
i want to copy a lot of data just like i see it.
and if i manualy type 1.1 and 1.2. when substracting, there is no reason in the world for it to be 0.0999999999999999
it should be 0.1. its like excel just invent numbers for me...