Question: how to set auto date format in excel?
Answer: Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format. ...  If you want to use a date format according to how another language displays dates, choose the language in Locale (location).