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!
Latest tech deals.
- AMD Ryzenâ„¢ 9 9900X 12-Core - was $499 now $331
- Sony INZONE M10S 27-inch - was $899 now $748
- Thermaltake LCGS View i1470S-170 - was $2,399 now $2,099
- Apple 2026 MacBook Air - was $1,999 now $1,891
- Bose QuietComfort Headphones - was $359 now $169
- LG 77-inch OLED C6 - was $2,499 now $1,999
- MSI Prestige 16 Flip - was $2,149 now $1,870
- Hisense 85-inch U6 Pro Series - was $1,999 now $997
Prices correct as of November 5th, 2026.
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:


