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)

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)

Tools/ Options/ Calculation/ uncheck "1904 date system"
--
David Biddulph

"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)

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)

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