I suspect you have a data type issue with the copy and paste - perhaps one column is supposed to be numeric (that would include dates) but is actually coming in as text.