I'm running Excel 2002 under Windows XP. When I enter a date in m-d-yy
format (for instance, May 10 as 5-10-09), Excel interprets it as Oct 5, 2009.

Here is what HAS NOT worked:
- Changing Excel's regional settings
- Changing Windows' regional date/time settings
These are defaulted to US settings, which should interpret 5-10-09 as May 10.

Any OTHER ideas as to what to try?
--
- Steve Eklund
Kansas City, MO