A
avklingler
When entering a date into Excel 2007 the values for the month & day are
automatically reversed. This has only begun happening recently, not sure when
& don't want to open other spreadsheets & possibly create the same problem.
The problem seems to be related to the date formatting. It happens with each
formatting choice. Example: choose 4-1-08 as April 1 2008, enter your date &
it is entered as 1-4-08 as January 4 2008. Have been using Excel for at least
20 years. The spreadsheet in question was upgraded to 2007 (xlxs) early March
2007. Is there a known problem with a recent update perhaps?
automatically reversed. This has only begun happening recently, not sure when
& don't want to open other spreadsheets & possibly create the same problem.
The problem seems to be related to the date formatting. It happens with each
formatting choice. Example: choose 4-1-08 as April 1 2008, enter your date &
it is entered as 1-4-08 as January 4 2008. Have been using Excel for at least
20 years. The spreadsheet in question was upgraded to 2007 (xlxs) early March
2007. Is there a known problem with a recent update perhaps?