Question: how to set the default date format in excel?
Answer: Click the Start button, and then click Control Panel.
Click Region and Language.
In the Region dialog box, click Additional settings.
Click the Date tab.
In the Short date format list, click a format that uses four digits for the year ("yyyy").
Click OK.