lets assume I am trying to separate a number into its integer and decimal fields. Ie: 159.2345 into 159 and 0.2345

When I separate the two fields, I am getting an incorrect number for the decimal field.

Dim A as double
Dim B as Integer
Dim C as double

A = 159.2345 In the debugger I can see that the decimal numbers do not extend beyond the 5
B = int (A) THE Variable value of B is correct (159)
C = A - B the Variable Value of C is incorrect (0.234499999999997)

The result for C confuses me. the thousandths and 1/10 thousandths places are no longer 45
I do not want to round C. this error ie revealing that I do not understand something.

Perhaps it is because I am mixing data types. C = A(Double) - B(Integer)
To test this theory out, I cast B into a Double but casting did not resolve my problem.

Anyone have any ideas?

I am running excel 365 home edition on W10 insider

bil