I have a notepad of unformatted birthdates. They look like:
If I highlight the first date and past it into excel, it returns 08/25/2025. I have already followed the instructions from microsoft about setting my regional language settings, found here:
I've attached a screen shot of what the regional settings now look like. I restarted my computer after I made the change.
My question is, how do I change the settings so that excel will interpret the date as 19XX instead of 20XX?