This problem has nothing to do with VBA. Of course, it can be handled in VBA. You have a few ways to solve this problem:
Convert the column you are going to paste into to text using the cell format.
Or copy as clear text when pasting so that the formats or formulas are not transferred.