Posted 1/17/2024 03:39 (#10578612 - in reply to #10578562) Subject: RE: Is there a way to change default year to 2023 for data entry in Excel?
Lenawee Co Michigan
You are right; I do have that setting. The default is 3/14/2001. I always change it to 3/14.
Read the bottom line though. Looks like if you change to a different format you can set the year with each entry, like 3/14/01. The 01 would be entered each time.
Is there a way to change default year to 2023 for data entry in Excel?
