"Phillip" wrote in message
...
On my companies host system we store dates with only two digit years and
we
use pivot dates to interpret correctly. When I create an extract of these
dates and import into excel they are not interpreted as the correct
century.
I have already changed the regional settings to accomodate this and when I
just key a date into excel cell such as 12/1/30 it comes back correctly as
12/1/2030. However, the same date in my import will come out as 12/1/1930.
I
think it has something to do with the import but I am not sure what.

Thanks for any suggestions.
--
PCastle

Open the Control Panel|Regional Options and click on the Date tab. Your
settings are probably such that a two digit year is interpreted to fall
between 1930 and 2029.

/Fredrik