{"id":375,"date":"2004-08-23T11:58:13","date_gmt":"2004-08-23T18:58:13","guid":{"rendered":"http:\/\/klishis.com\/notreally\/archives\/375"},"modified":"2004-08-23T11:58:13","modified_gmt":"2004-08-23T18:58:13","slug":"i-hate-microsoft","status":"publish","type":"post","link":"https:\/\/klishis.com\/notreally\/archives\/375","title":{"rendered":"I. Hate. Microsoft."},"content":{"rendered":"

You can’t even believe<\/i> how much I hate Microsoft.<\/p>\n

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. <\/p>\n

No good.<\/p>\n

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.<\/p>\n

Apparently Excel doesn’t recognize dates before 1900.<\/p>\n

How STUPID is THAT? I mean REALLY? HOW FROGGING STUPID IS THAT?<\/p>\n

So I had to put my data back into Word, and run the sort there, because WORD recognizes dates before 1900.<\/p>\n

Grrr……<\/p>\n

ADDENDUM the First<\/b>: This<\/a> is what I was trying to do.<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-375","post","type-post","status-publish","format-standard","hentry","category-non-sequiturs"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pefxA-63","_links":{"self":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/comments?post=375"}],"version-history":[{"count":0,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts\/375\/revisions"}],"wp:attachment":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/media?parent=375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/categories?post=375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/tags?post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}