I’m running into the same issue. Nothing I do seems to “lock” the column format; pasting always adapts the format to something else (namely the Select List). This seems more like a bug than an intended feature (I like the auto-adapt feature but I doubt Codans wanted it to convert columns of all numbers or currency to list items).