I have a problem importing dates with 2 digit year format. When importing
dates with a 2 digit year format, the conversion doesn't follow the regional
date and language settings. For example if I import 3/23/33, it is
interpreted as 3/23/1933 even though I've changed the regional date settings
to interpret up to 35 as the 21st century. If I type 3/23/33 directly into
Excel, it is interpreted as 3/23/2033 as expected. Why is the import process
not interpreting the correct century according to the regional date settings.

Thanks,

Mark