Sep 19 2022 11:57 AM
I have a financial ledger where I input date purchased so I'm only working in current year. Excel has been no problem with my method for years but out of the blue it is correcting my dates. I always type in an abbreviated date like "oct 13" or aug 8" and Excel would put it into long and end up with August 8, 2022. Now Excel is reading my inputted number as the year so all my entries from hereon are the 1 of the month and that number I typed becomes the year. For example, August 1, 2008 or October 1, 2013. I've tried changing long date, short date, and playing with date layout in the format cell window, but nothing is making that column default to 2022.
Sep 19 2022 01:11 PM
Sep 19 2022 01:28 PM
@mathetes not a bad idea but unfortunately it still changes 9/19 to September 1, 2019.
Sep 19 2022 02:43 PM