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

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

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.

"Steve Eklund" wrote:

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

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

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.
--
- Steve Eklund
Kansas City, MO


"Sheeloo" wrote:

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.

"Steve Eklund" wrote:

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

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

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.

"Steve Eklund" wrote:

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.
--
- Steve Eklund
Kansas City, MO


"Sheeloo" wrote:

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.

"Steve Eklund" wrote:

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