Question: how to change the default date format in excel 2016?
Answer: Select the cell (or cells) you want to format. Display the Home tab of the ribbon. Click the small icon at the bottom-right corner of the Number group. ...  Click Date at the left side of the dialog box. ...  Using the Locale drop-down list, choose a country or region that uses the date format you want to use.