A user I support is having an issue with a worksheet in Excel. It is
not an urgent or crucial fix, but I am interested in people's ideas,
since she says it has happened to her before. In each case she threw
away the worksheet and started a new one by hand entering the data again.

Here's the scenario: She has a worksheet in which she has been adding
rows of data over time (6 months or so) and has only about 30 rows of
data. Column A are dates, and are formatted as such.

After months of opening and saving in this document once a week or so,
she now has an issue - when she types in a date, it gives her bizarre
dates from the future. For example, when she enters 8/01/05 by hand,
the date displayed in the cell is 4/26/2119.

Things I know:

The 1904 date system is not checked in Tools/Options/Calculations

The worksheet works fine on my computer when she emails it to me

We have cleared the formatting on the cell, and the entire column

The local system time is correct



Has anyone seen such issues?

- Chris in Nebraska