Regional options and excel - 2 exceptions

windows doesn't change the format between dd-mmm-yy and dd-mmm-yyyy

also , windows doesn't handle yyyy-dd-mm properly

as you can see, it can't read 1999-23-01, therefore the format is general
1999-03-02, it can read and  does 2 boo-boos - it reads the day as the month and it formats it as dd-mm-yyyy


also interesting - dd-MMM-yy applied to 2-3-1999 produces 02-03-99 - no month string.