| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 date entry: Cannot get away from d-m-yy entry format
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with entry of date format | Excel Discussion (Misc queries) | |||
| Change from american date entry format | Excel Worksheet Functions | |||
| How to format Date for 6 digit entry without entering / | Excel Worksheet Functions | |||
| Excel 2002 : Is there any active row bar to aid data entry ? | Excel Discussion (Misc queries) | |||
| Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
Threaded Mode
