Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. Select the cells that contain the dates to format, and press Ctrl+1 to open Format Cells.

  2. Under Category on the left, select Date. 

  3. 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.