excel defaults to current year

[tiredofusernames]

Hi, never had a problem until upgraded to Windows 10:

I have a spreadsheet containing a column of dates in mmm-yy format. eg Jun-17 but when I enter Jun-17, Excel defaults to Jun-18. Same thing happens If I enter Jun-19, it just defaults to Jun-18. Can anyone Help? I am using Office 2013.

 

[mole999]

if you look at the cell with the full date is it 1/6/18, you might enter jun 19, nut it could be stored as 19/jun/18 and what you see is just that

 

[tiredofusernames]

Hi, never had a problem until upgraded to Windows 10:

I have a spreadsheet containing a column of dates in mmm-yy format. eg Jun-17 but when I enter Jun-17, Excel defaults to Jun-18. Same thing happens If I enter Jun-19, it just defaults to Jun-18. Can anyone Help? I am using Office 2013.

Thank you mole999 - It was exactly what you said.

 

[mole999]

I guess you need to add the 1st to each entry and that would control it