Tuesday, March 12, 2013

The joy of working the Microsoft way.

Microsoft Excel is dead certain I would like to store my dates in MM/DD/YYYY format, even though I've entered them as YYYY-MM-DD and specified this to be my display format. The most baffling part is that YYYY-MM-DD is auto-corrected to MM/DD/YYYY, yet YYYY-MM-DD is not a format selection - it must be manually specified.

I'm mostly surprised Excel didn't think I meant YYYY minus MM minus DD.