Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change in the way excel interprets dates
My Excel 2007 spreadsheet used to interpret the entry Mar 19 as March 19,
2009 (or whatever the current year was). Now when I enter Mar 19 the number is interpreted as March 1, 2019. Excel used to interpret the number following the month as the day, but now it assumes it is the year. I didn't change anything, to my knowledge, and I have been using the same spreadsheet for years. Any idea how to tell Excel how to correctly interpret the date entered? (Note that this isn't a formatting question. I can get it to display the date in any format, but the date is always misinterpreted. I realize I could enter the date in a mm/dd/yy or dd/mm/yy way, but I'm just wondering why Excel used to interpret my quick entry correctly and now doesn't. -Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change in the way excel interprets dates
Someone has changed your Short Date in Control PanelRegional and Language
Options to dd/MM/yyyy Go into CP and reset short date to MM/dd/yyyy OR.........type 19 Mar instead or Mar 19 Gord Dibben MS Excel MVP On Tue, 09 Jun 2009 20:01:23 GMT, "RobSmy" <u52478@uwe wrote: My Excel 2007 spreadsheet used to interpret the entry Mar 19 as March 19, 2009 (or whatever the current year was). Now when I enter Mar 19 the number is interpreted as March 1, 2019. Excel used to interpret the number following the month as the day, but now it assumes it is the year. I didn't change anything, to my knowledge, and I have been using the same spreadsheet for years. Any idea how to tell Excel how to correctly interpret the date entered? (Note that this isn't a formatting question. I can get it to display the date in any format, but the date is always misinterpreted. I realize I could enter the date in a mm/dd/yy or dd/mm/yy way, but I'm just wondering why Excel used to interpret my quick entry correctly and now doesn't. -Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel interprets Text String as value in logical Argument | New Users to Excel | |||
access dates in excel, how to change format? | Excel Discussion (Misc queries) | |||
Why does Excel change the dates I input? | Excel Worksheet Functions | |||
Excel dates change | Excel Worksheet Functions | |||
Why do my dates change when I copy them between Excel worksheets? | Excel Worksheet Functions |