Like a high school freshman party, that’s a weak punch.
Like a high school freshman party, that’s a weak punch.
If you precede all your data with an ', then excel won’t auto convert it total a date. Seems silly to do this for all the data though.
I think the joke is okay and would have worked if I didn’t have to make sense of a number of confusions I had to work through first.
I don’t know if anyone else has these problems to work through, but having had to work through them muted any enjoyment I would have gotten from the joke had that been absent.
Wait, so if I were to import a csv with data that would normally be interpreted as a date by excel, but preceded that data with an apostrophe, it would still recognize that as a date? I’ve never tested this, so I’m not sure.
Relatedly, I know someone who was working some ssn data. Unfortunately, if an SSN started with a 0, it would drop that 0. It was a mess for them. I think there was a recent release that allowed you to not ignore leading 0’s.