-
Select the cells that contain the dates you want to format, and press control+1 to open the Format Cells dialog.
-
Under Category on the left, select Date.
-
Under Type on the right, choose the date format you want, then select OK.
Tip: For info on how to customize the format, see Format numbers as dates or times.
-
Select the cells that contain the dates you want to format, and press Ctrl+1 to open the All format options pane on the right.
-
Under Category on the left, select Date.
-
Under Type on the right, choose the date format you want, then select OK.
Tip: For info on how to customize the format, see Format numbers as dates or times.