View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default date format changes

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)