Excel Dates

  • Thread starter Auto-changing dates in Excel cells
  • Start date
A

Auto-changing dates in Excel cells

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?
 
T

Tushar Mehta

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

Utf-8?B?QXV0by1jaGFuZ2luZyBkYXRlcyBpbiBFeGNlbCBjZWxscw==?=" <Auto-
changing dates in Excel [email protected]> says...
 
A

Alex

Ok.

Go to Tools>Options>Calculation 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
 
Top