Typing month and day, excel assumes day is the year

[tiggynook]

I do not have the patience right now to figure this out on my own. I just changed computers yesterday and now all these little annoyances are popping up.

I used to type a date into excel as "apr 17" and it displayed the date as 17-Apr-14, which is exactly how I wanted it to.

Now, with my new computer, I type "apr 17" and get the date 01-Apr-17.

I have changed the format of the cell to date, with the type set to 14-Mar-01. I have even tried changing the format to date, custom dd-mmm-yy and still get the same issue.

I want excel to recognize I am only entering the month and day and to automatically input the current year. I do not want to type the year every time I make a data entry.

Thank in advance for any help.

[martindwilson]

change your settings in control panel /regional settings to us english maybe

[tiggynook]

Yes it worked.

Thank you for taking the time to respond!