Excel 2002 date entry: Cannot get away from d-m-yy entry format

  • Thread starter Thread starter Steve Eklund
  • Start date Start date
S

Steve Eklund

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?
 
Is this happening in every workbook/every cell?

If it is happening in a few particular cells then check their format... it
might be d/m/yyyy

What is the format you see on the Windows taskbar... it should be mm/dd/yyyy

Enter the date 5/13/09 in a cell. Open Edit->Format Cells dialog
Choose Custom
Type mm-dd-yyyy and see how the result is shown.
 
Excel's cell-formatting options do not affect how it interprets dates entered
by the user -- only how they are displayed.

I'm not at the computer with the problem, so I can't answer your question on
the Windows taskbar date format.
 
You seem to be offended by my suggestion to check the display format... We
have no way of knowing the Excel 'sophistication' of the person seeking
help...

Pl. post your request again so that others can help you.
 
Back
Top