No, only the year changes. The format is in both cases YYYY-MM-DD

"Bob Phillips" wrote:

Are the dates formatted like Jan30 etc?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Lindebo" wrote in message
...
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)