Oh, come on. Just format the range as text before pasting or importing the data (right-click -> format cells -> category = text). Text-formatted ranges don't c

Oh, come on. Just format the range as text before pasting or importing the data (right-click -> format cells -> category = text). Text-formatted ranges don't convert input data. The article also doesn't help saying that there is a toggle for implicit conversions. You want text, you preformat as text. Just learn to use the damn thing before you bash it. Especially if it's your daily driver.