Question: how do i 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.