Question: how to change default date format in ms excel?
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.