May 01 2023 06:22 PM
For years I've been entering dates on a spreadsheet in the format yyyy/mm/dd. Now Excel has gotten "smart" and reverses them to dd/mm/yyyy. I can now only correct new entries by laboriously customizing each entry. There must be some way to universally reset the format to my original form. But how?
May 02 2023 12:57 AM
May 07 2023 05:41 AM
May 07 2023 06:01 AM - edited May 07 2023 06:04 AM
Press Windows key+R to activate the Run dialog.
Enter control international and press Enter or click OK.
Click the Additional settings... button.
Activate the Date tab.
You can enter your preferred short date format in the box, for example yyyy/MM/dd:
Click OK to confirm.
May 07 2023 09:29 AM