Problem with decimal points

I am using Vlookup to compare our item number with the suppliers item number but the result is removing the decimal point on some but not all items. I would greatly appreciate any help as I have tried everything to try and get the points without success. I have included a small sample but it concerns almost 10.000 items.

Regards,
Andrew O' Brien