I am pasting information from a website into a column in excel. when i paste the data, it automatically formats the info as a date, even though i do want the date format. i tried going to format > cells > number > text, and then tried pasting the data, but my formatting is overridden, and it reformats the data as dates. is there a way to turn off autoformatting so that the data i paste into cells does not format unless i choose to format it?