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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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) |