You can’t even believe how much I hate Microsoft.

I have some data that I want to sort by date, so I copy the data into Excel, run the sort, and then discover that Excel has put the column in alphabetical order.

No good.

So I spent an hour playing with the formatting in Excel and Word, trying different varations of Paste Special. Nothing. Only a handful of dates will format as ‘date’ the rest remain formatted as text. Just as I’m about to (loudly) lose my mind, I realize that all the data that formatted correctly has something in common: all those dates are after 1900.

Apparently Excel doesn’t recognize dates before 1900.

How STUPID is THAT? I mean REALLY? HOW FROGGING STUPID IS THAT?

So I had to put my data back into Word, and run the sort there, because WORD recognizes dates before 1900.

Grrr……

ADDENDUM the First: This is what I was trying to do.