I have sometimes had Excel force pasted data into date format, even after I've explicitly set the entire row to text format. I had to go back and manually retyp

I have sometimes had Excel force pasted data into date format, even after I've explicitly set the entire row to text format. I had to go back and manually retype every date-like entry. It doesn't always do this, but it's frustrating as hell when it does. I can see even an attentive researcher being tripped up by that.