What happens if she uses the format painter and copies the format from a
good formatted cell to these cells?
http://www.officearticles.com/misc/f...oft_office.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Chris in Nebraska" <cpultz2@gmail.com> wrote in message
news:eSsvT83lFHA.2156@TK2MSFTNGP14.phx.gbl...
> 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