Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. On the Home tab, select the arrow next to the Number Format box, and choose More Number Formats.

    Number format box

  2. Under Category, select Date or Time.

  3. Choose the type and locale from the options given, and select OK.

Need more help?

Want more options?

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