date format changes

L

Lindebo

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

Bob Phillips

Are the dates formatted like Jan30 etc?

--

HTH

Bob Phillips

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

Dave Peterson

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).
 
Top