If the dates are off by 4 years and one day...

One way to add those four years back is to find an empty cell, put 1462 into
that cell.

Copy that cell.

Select your range that contains the dates. Edit|PasteSpecial|click Add (in the
operation box).

Lindebo wrote:

I made a data import (Import External Data) from an access database into Excel

All dates in access changed from year 2006 to year 2010.

How can this be avoided?

Lindebo (sweden)

--

Dave Peterson