Pasting 12/31/39 from Access or Word to Excel populates 1939 vs. 2039

[metsmaniac]

When I copy 12/31/39 from MS Access 2013 or Word 2013 to Excel 2013, the result populates as 12/31/1939 vs. 12/31/2039.

I've checked the Region & Language settings in the control panel. They are set to treat 2-digit year entries as years between 1950 and 2049.

Entering 12/39 directly into Excel results in 12/31/2039, as it should.

In MS Access, sorting the date column in a table places 12/31/39 at the bottom, as it should.

I don't understand why the Microsoft Copy/Paste functions for 12/31/39 aren't interpreted correctly in Excel.

I'm using Windows 10 Pro.

 

[mole999]

how does excel know Entering 12/39 directly into Excel results in 12/31/2039, as it should. is the last day of the month ?

 

[metsmaniac]

Excel knows that entering 12/39 is 12/31/2039 vs. 12/31/1939 because of a Windows setting in the Region Item in the Control Panel. In the Date tab of Additional Settings in Region (and in Language), the Calendar setting determines how a 2-digit year is treated. My calendar is set to interpret a 2-digit year (YY) as 20YY, because the range is set for years between 1950 and 2049.