How to change date format in Excel – Windows and Mac

Table of Contents
Want to know how to change date format in Excel? We’ve got you covered.
In the Excel control panel, there is a default date setting that is triggered anytime data is input to a cell in the format of number/number, for example, if you input 3/3 or 03/03 then this would trigger the default date format to change this to 3-Mar. However, not everyone wants this format, so they’re always looking for a way to change date format in Excel.
To help you out, we’re going to explain how you can quickly change the date format in Excel on both Windows and Mac. So, without any further ado, let’s get to it!
Today's best deals
- Intel Core Ultra 245K - 15% OFF NOW!
- ASUS ROG Swift PG32UQXR - $200 OFF NOW!
- Yeyian Yumi RTX 4060 Gaming PC - $500 OFF NOW!
- SAMSUNG 990 PRO 4TB SSD - 35% OFF NOW!
- Sony X77L 4K Smart TV - 16% OFF NOW!
- Samsung Galaxy Tab A9+ - 29% OFF NOW!
- WD_BLACK 8TB SN850X SSD - 32% OFF NOW!
*Stock availability and pricing subject to change depending on retailer or outlet.
How to change date format in Excel on Windows and Mac
Here’s how you can change the date format in Excel. The method is same for both Windows and Mac users, but those with Mac will just have to press a different button.
Step
Select the cell
First, select the cell which contains a date.
Step
Open the settings menu
Now, after selecting the cell, press CTRL + 1 on your keyboard. If you’re using a Mac, press Command + 1. This will pop up a settings menu on the screen.
Step
Navigate to date
Click on the Numbers tab, then go to Date. This can be found on the left side.
Step
Choose a format
From the Type: section, choose your preferred format, and click on OK.
This will change the format of the date.
If you wish to create a custom date format in Excel, you can go to Custom instead of Date in the menu, and type your custom format there.
What are short date format and long date format in Excel?
These are two date formats that you can quickly select from a drop-down menu. The short date format appears as 14/02/2024 while the long date format appears as Wednesday, 14 February 2024. To access these two formats, you have to click on the cell with the date, go to the Home tab, click on the drop-down menu above the Number section, and select short or long date format from there.
Final thoughts
We hope that this guide has been of help to you and that you will now be able to change the date format in Excel without any difficulty. Mastering Excel is not as difficult as it seems, all it takes is some patience and practice! If you want to learn more about Excel and its features, you can follow these guides: