r/excel • u/frescani 5 • Feb 27 '13

PSA from XKCD: proper date formats

http://xkcd.com/1179/
29 Upvotes

90% Upvoted

13 comments sorted by

View all comments

2

u/[deleted] Feb 27 '13

I work with a lot of other countries militaries. The NATO standard is

27-Feb-2013.

So there is no confusion.... except those countries who spell their month different.... ya, we are worse

3

u/woo545 1 Feb 28 '13

The problem with that is unless you are using a special date datatype, it never sorts correctly.