Question: how to set default date format in excel mac?
Answer: Select the cells you want to format. Press Control+1 or Command+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format.