Excel Dates
 

Whenever I initially enter a date, e.g., 6/1/2001, into a cell in an Excel
spreadsheet, it is auto changed to make the year the current year, e.g.,
6/1/2005. When retyped as 6/1/2001 the cell will then retain this date but
I'm continually forced to double my efforts on date entries. This occurs on
all worksheets including old, previously developed ones and newly opened
ones. Any ideas why?

Are you sure you are entering the year? XL assumes the current year if
you only enter dd and mm, but I have not seen it change a specified
year into the current one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?QXV0by1jaGFuZ2luZyBkYXRlcyBpbiBFeGNlbCBjZWxscw ==?=" <Auto-
changing dates in Excel says...
Whenever I initially enter a date, e.g., 6/1/2001, into a cell in an Excel
spreadsheet, it is auto changed to make the year the current year, e.g.,
6/1/2005. When retyped as 6/1/2001 the cell will then retain this date but
I'm continually forced to double my efforts on date entries. This occurs on
all worksheets including old, previously developed ones and newly opened
ones. Any ideas why?

Ok.

Go to ToolsOptionsCalculation Tab.

At the bottom I think you will find that the '1904 Date System' is checked.

Uncheck it and that will solve the problem...


Alex

"Auto-changing dates in Excel cells" wrote:

Whenever I initially enter a date, e.g., 6/1/2001, into a cell in an Excel
spreadsheet, it is auto changed to make the year the current year, e.g.,
6/1/2005. When retyped as 6/1/2001 the cell will then retain this date but
I'm continually forced to double my efforts on date entries. This occurs on
all worksheets including old, previously developed ones and newly opened
ones. Any ideas why?