Excel Mac: Change the Default Date Format for New Workbooks

To change Excel’s default date format on a Mac, first adjust the date format in macOS under System Settings > General > Language & Region, then restart Excel and check a new workbook. For a consistent format in every new workbook—or a format not offered by macOS—save a formatted workbook as Excel’s default template, Book.xltx.

What “default date format” means in Excel

Excel does not have one simple preference that changes every date in every workbook. The date format you see depends on where the date is entered and what formatting is already applied to that cell. In a new workbook, Excel generally uses the system’s regional settings when it assigns a default date display to a newly entered date. Existing workbooks can have their own cell formats, which remain in place even if you change macOS settings.

It is also useful to separate a date’s stored value from its appearance. Excel stores recognized dates as numbers and applies a number format to display them as dates. For example, the same date value might appear as 11/3/2026, 3-Nov-2026, or 2026-11-03 depending on the cell’s format. Changing the format changes how the value looks; it does not change the date itself.

That distinction explains why changing a Mac setting may affect dates you enter into a new, General-formatted cell but not dates in a workbook that has already been formatted. It also explains why simply typing a different-looking date does not always produce the display you expect.

Change the Mac’s regional date format

Use this method when you want Excel’s usual default date display to follow your Mac’s regional date preference. The wording and available choices can vary slightly across macOS releases, but the setting is in Language & Region:

Save your work and open the Apple menu, then choose System Settings.
Select General, then Language & Region.
Review the Region and Date format settings. Choose the region or date-format option that matches the display you want, if it is available.
Close Excel completely and reopen it. Create a new blank workbook and enter a date in a cell that has not been given a custom number format.

Test with a date that is not ambiguous, such as the 20th of a month, so you can distinguish day-first and month-first displays. For example, a date could display as 20/11/2026 in a day-first format or 11/20/2026 in a month-first format. If the system offers only preset date styles and none matches your preferred pattern, use Excel cell formatting or a default workbook template instead.

Changing the Mac’s region can affect more than Excel dates: it may influence how other apps present dates, numbers, and related regional conventions. If you only want to change one spreadsheet, changing the cells’ format is usually a more targeted choice.

Format dates in the current workbook

For a workbook you already have open, format the relevant cells directly. This is the most dependable approach when you want a specific display in that file, regardless of the Mac’s regional setting:

Select the date cells, a whole column, or the range where dates will be entered.
On the Home tab, open the Number Format menu and choose More Number Formats. You can also use Format > Cells and select the Number tab if that menu is available in your Excel layout.
Choose a date category and select a suitable format. If you need a particular pattern, choose Custom and enter a format code, such as yyyy-mm-dd or dd-mmm-yyyy.
Select OK, then enter or paste dates into the formatted cells.

For example, yyyy-mm-dd displays a date like 2026-11-03, while dd-mmm-yyyy displays it like 03-Nov-2026. A format such as mmm d, yyyy displays Nov 3, 2026. These formats can make reports easier to scan and reduce confusion between dates such as 04/05/2026, which can mean April 5 or May 4 depending on the convention.

Formatting a whole column before entering dates can save time, but it does not force Excel to recognize every pasted value as a date. Text imported from another system may remain text, even when the cell looks date-formatted. Formatting affects recognized numeric dates; it cannot by itself convert arbitrary text into a date value.

Set a format for future blank workbooks

If you want the same custom date format whenever you choose New Blank Workbook, use a default workbook template. This is a practical way to set up a date column or several sheets in advance. It is separate from the macOS regional setting and does not retroactively alter existing files.

Create a new workbook in Excel for Mac.
Format the date cells, columns, or sheets as you want them to appear in future workbooks. You can also set other starting details, such as column widths, if they are genuinely useful in each new file.
Save the workbook as an Excel template named Book.xltx.
Place the template in Excel’s XLSTART folder. In current Microsoft 365 installations, a common user folder is ~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel. In Finder, choose Go > Go to Folder to enter that path; the Library folder is normally hidden.
Quit and reopen Excel, then create a new blank workbook to check that the template is being used.

The exact startup-folder location can vary with the Excel installation, so if the template is not picked up, verify that it is in the XLSTART folder used by your copy of Excel. The template affects new workbooks created from Excel’s default blank-workbook command; it does not rewrite files you open, and it is not the same as saving an ordinary workbook with a different name. Keep a separate copy of the template if you may want to edit or replace it later.

Choose a date format that suits the data

The best format depends on who will read the workbook and how it will be shared. A numeric day/month format is compact, but readers in different regions may interpret it differently. A month name removes that ambiguity, while an ISO-style year-month-day display is often convenient for sorting and exporting when the values are genuine Excel dates.

For everyday local use: follow the date convention familiar to the workbook’s main audience.
For reports shared across regions: consider a month name, such as 3-Nov-2026, or a year-first display such as 2026-11-03.
For narrow columns: a shorter display may fit better, but check that the year remains clear where it matters.
For data entry: format the destination cells first and give users a clear example of the expected input convention.

Custom date codes have a few details worth knowing. In a date format, m represents a month; in a time format, it can represent minutes, with its meaning determined by context. Use mmm for an abbreviated month name and mmmm for a full month name. Use yy or yyyy to control whether the year appears with two or four digits. A four-digit year is generally clearer in records that may be read later.

Why a date may not change when you edit the setting

If the display stays the same, the cell may already have an explicit number format. Changing the Mac’s regional preference does not normally override a format saved in an existing workbook. Select the cell and inspect its number format; apply a new date format if you want that cell to look different.

Another common issue is that the entry is text rather than a recognized date. A cell formatted as Date can still contain text copied from a web page or exported file. A clue is that changing its number format has no effect, or that Excel does not treat it like a date in sorting or calculations. In that case, the data needs to be converted into actual date values; repeatedly changing the display format will not fix the underlying text.

Ambiguous input is a separate problem from display. If you type 04/05/2026, Excel may interpret it according to regional conventions, then display the interpreted value in the chosen format. A format change cannot reliably correct a date that Excel already interpreted as the wrong day and month. For important imported or shared data, use an unambiguous input method and verify a few values after entry.

Finally, changing a column’s format does not change how a date appears in every other place. A chart axis, pivot table, or text string may have its own formatting or may be displaying a separate representation. Check the specific element that looks wrong rather than assuming the whole workbook shares one date setting.

Mac, Windows, and Excel for the web

On a Mac, Excel’s default date behavior is tied to macOS regional settings, and the app’s menus and system preferences are the relevant places to check. On Windows, regional date conventions are controlled through Windows regional settings rather than macOS System Settings. In both desktop versions, formatting selected cells in the workbook is the direct way to set a display for that file.

Excel for the web runs in a browser and does not use the Mac desktop app’s XLSTART template mechanism. If a workbook is stored online, its saved cell formatting travels with the workbook, but browser and account regional preferences can affect how dates are interpreted or presented in some contexts. For a workbook that must look consistent to collaborators, explicitly format its date cells and check the shared file rather than relying only on one person’s computer settings.

Frequently Asked Questions

Can I set one date format for every Excel file on my Mac?
There is not one setting that rewrites every workbook. The Mac’s regional preference influences default date behavior, while existing files can retain their own formats. A Book.xltx template can set up new blank workbooks, but already-saved workbooks need to be formatted individually.

Will changing the Mac date format change dates already in a spreadsheet?
Usually not if those cells already have a saved number format. Change the selected cells’ format in Excel to alter their appearance. The underlying date value is normally unchanged when you change only its number format.

Can I use yyyy-mm-dd as the default?
Yes. Apply the custom format yyyy-mm-dd to the relevant cells in a workbook, or include that formatting in a Book.xltx default template. macOS may not offer that exact custom pattern as a system-wide preset.

Why does Excel show a number instead of a date?
Excel dates are stored as numbers, so a cell using General or Number formatting may display the underlying serial value. Apply a date format to a recognized date value. If the value is text, changing the format alone will not convert it.

Does changing the date format change the date itself?
No, changing a cell’s number format changes its display, not its stored date value. However, changing regional settings can affect how Excel interprets newly typed ambiguous dates, so check entries such as 04/05/2026 carefully.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.