Re: I must be missing something...
UPVOTE. I was literally about to post the exact same thing. I know people aren't all stupid, but really how difficult is it to define a spreadsheet column as text. I've had that problem myself when some entry in a spreadsheet column is defined by the spreadsheet as a date field. Right click, define as text, it's probably different in different software but takes two ticks (2 February 1943 to genetic scientists)