Ok, I can get them to paste in correctly by formatting the cells as text, then using "paste special", but if I format the cells then use the text import tool it still changes them, even if I have "preserve cell formatting" checked.