Question: how to change date format in excel for all cells?
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.