2 Digit year when importing

Change the way two-digit years are interpreted

If you enter a date with a two-digit year in a text formatted cell or as a text argument in a function, such as =YEAR("1/1/31"), Excel interprets the year as follows:

• 00 through 29     is interpreted as the years 2000 through 2029. For example, if you type the date 5/28/19, Excel assumes the date is May 28, 2019.

• 30 through 99     is interpreted as the years 1930 through 1999. For example, if you type the date 5/28/98, Excel assumes the date is May 28, 1998.

In Microsoft Windows, you can change the way two-digit years are interpreted for all Microsoft Windows programs that you have installed.

1. Click the Start button, and then click Control Panel.

2. Do one of the following:

   • In Windows Vista, click Clock, Language, and Region.

   • In Windows XP, click Date, Time, Language, and Regional Options.

3. Click Regional and Language Options.

4. Do one of the following:

   • In Windows Vista, in the Regional and Language Options dialog box, click the Formats tab.

   • In Windows XP, in the Regional and Language Options dialog box, click the Regional Options tab.

5. Do one of the following:

   • In Windows Vista, click Customize this format.

   • In Windows XP, click Customize.

6. Click the Date tab.

7. In the When a two-digit year is entered, interpret it as a year between box, change the upper limit for the century.

    

   As you change the upper-limit year, the lower-limit year automatically changes.

Source: Microsoft Office Support Website

https://support.office.com/en-us/article/Change-the-date-system-format-or-two-digit-year-interpretation-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f