Pasting numbers sometimes turns cells into select list

[Ian_Nicholson]

For posterity, here’s a link to a previous discussion on this:

Pasting data changes column formats

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).