How to Change the Default Date Format in Google Sheets

To change the default date format in Google Sheets, open the spreadsheet and choose File > Settings, then select the preferred Locale under General and save the settings. For a different format in particular cells, select them and choose Format > Number > Custom date and time; the locale setting affects the spreadsheet more broadly, while cell formatting lets you control specific dates.

What “default date format” means in Sheets

Google Sheets has two related controls that people often mean when they ask about a default date format. The spreadsheet’s locale sets regional conventions for dates, numbers, and currency. Separately, the number format applied to a cell determines how a date value appears in that cell. Locale is the setting to change when dates across a spreadsheet should follow another region’s conventions. Cell formatting is the better choice when you want a particular column or report to use a chosen pattern without changing other regional settings.

A date in a properly recognized date cell is a value, not just a printed string. Sheets can use that value in date calculations, sorting, and charts, while its number format controls what people see—for example, a month before a day or a four-digit year. Changing how the date looks generally does not change the underlying date. But changing a spreadsheet’s locale can also affect how newly entered or imported date-like text is interpreted, so it is worth checking important data afterward.

Change the spreadsheet’s locale

Open the spreadsheet in Google Sheets in a web browser.
Choose File > Settings.
On the General tab, open the Locale menu and select the region whose conventions you want.
Save the settings. If prompted, allow the spreadsheet to reload, then check representative dates and numbers.

The locale applies to the spreadsheet, not just the currently selected cells. It can change the default conventions used for dates, number separators, and currency. For instance, a date such as 04/05/2026 can be read as April 5 in one convention and 4 May in another. That ambiguity is why a locale change deserves a quick review, especially in a sheet with dates typed as text or imported from another system.

There is no single date pattern that is right for every spreadsheet. Choose a locale based on the people entering and reading the data, and use explicit cell formatting when a report needs a consistent display regardless of local convention. A spreadsheet’s locale is a property of that file, so collaborators can see the same file-level settings rather than each user silently applying a personal date preference.

Set a format for selected cells

If the locale is already right but one date column should display differently, format the cells directly. Select the date cells, then choose Format > Number and select a date option, or open Custom date and time to build a pattern. The available choices and examples may reflect the spreadsheet’s locale.

Common patterns include a numeric month/day/year display, a day followed by a written month, or a year-month-day display such as 2026-04-05. In the custom date and time editor, choose the components and their order, then apply the format. For a column of dates, select the whole column or the intended range before applying it; new entries in that range will generally use the chosen cell format as well.

Use a compact numeric pattern when space is limited and everyone understands the order.
Use a written month, such as 5 Apr 2026, when readers may confuse day and month.
Use a year-first pattern for logs or lists that need to sort clearly by date.
Include a time component only when the time of day matters; a date-only display can hide a time that is still stored in the cell.

Formatting a cell is not the same as changing its value. If a cell contains a valid date and you change the display from 4/5/2026 to 5 Apr 2026, Sheets is showing the same date in another form. If the contents are plain text, however, changing the number format may do nothing: Sheets cannot display text as a date merely because a date format was selected.

Choose between locale and cell formatting

Use the locale setting when the spreadsheet’s regional defaults should change—for example, when a team works with a different date convention and also needs appropriate number and currency conventions. Use a cell format when the goal is narrower, such as making one report column unambiguous or standardizing a published table. These settings can be combined: a file can use one locale while a particular column has a deliberately chosen date pattern.

For shared work, consider the audience rather than only the creator’s preference. A date written as 03/04/2026 is not self-explanatory to readers who use different conventions. A pattern with a written month or a year-first order can reduce that confusion. If people are entering dates, give them a clear instruction about the expected order and keep the locale appropriate for the data-entry workflow.

Changing locale is broader than changing the appearance of one date column. It can affect number and currency defaults and how new entries are understood. If the only issue is that a report prints dates in an unexpected order, changing the cells’ number format is usually the more targeted fix. Conversely, applying a custom pattern to a few cells does not change the locale or make every other date in the file follow that pattern.

What happens to existing dates and imported data

After a locale change, inspect both dates already in the spreadsheet and dates added afterward. Cells with an explicit number format may continue to show that chosen pattern, while cells relying on automatic or default formatting can reflect regional conventions. The exact appearance depends on the cell’s existing formatting, so do not assume that a locale change will restyle every date exactly as intended.

Imported CSV files and pasted data deserve special attention. A string like 04/05/2026 may be interpreted differently depending on the spreadsheet locale and the source’s convention. If Sheets recognizes it as a date, it can usually be reformatted. If it remains text, date sorting and calculations may not behave as expected. Check a few values against the source data before applying a format to an entire column; a display change cannot repair a date that was parsed as the wrong day or left as text.

For important records, keep an unmodified copy before changing locale or performing bulk conversions. Check the first, middle, and last rows, along with any dates near month boundaries. Those checks can reveal a swapped day and month or a text value that a quick glance at ordinary dates would miss. In a shared spreadsheet, let collaborators know before making a file-wide setting change.

Locale, time zone, and spreadsheet language

Locale is not the same as time zone or the language of the Sheets interface. Locale concerns regional conventions for dates, numbers, and currency. A spreadsheet also has a time-zone setting, which matters for time-based values and functions that use the current date or time. Changing the locale is not a way to shift a timestamp to another time zone. If a date includes a time and appears to move by hours, check the time-zone setting and the value’s underlying contents as well as its number format.

The menus and help text you see can depend on your Google account or interface language, but that is separate from the spreadsheet’s locale. A person can use Sheets in one interface language while a particular file uses another locale. This distinction is useful when a team shares a sheet across countries: the file’s data conventions can be set for the work, independently of each collaborator’s menus.

Common problems and how to fix them

The date does not change after formatting. It may be text rather than a recognized date value. Check whether Sheets treats it as a date, then convert or re-enter it using an unambiguous method before applying a date format.
The day and month appear swapped. The value may have been interpreted under a different locale. Verify it against the original source; changing the display alone will not correct a value that was parsed incorrectly.
Only some cells change. The range may contain different existing formats, or you may have selected only part of the column. Select the intended range and apply the desired format consistently.
A date shows a number instead. The cell may be displaying the underlying date serial as a number. Apply a date format from Format > Number.
The date looks right but sorts oddly. Some entries may be text while others are date values. Consistent data types are important for sorting, filtering, and date-based calculations.

When troubleshooting, distinguish three questions: what value is stored, how Sheets interpreted the input, and what display format the cell uses. Those are related but separate. Confirming the stored date first prevents a formatting change from disguising a data-entry mistake.

Frequently Asked Questions

Can I set a different date format for just one column?
Select the column or range and choose Format > Number, then choose a date format or Custom date and time. This changes the selected cells’ display without changing the spreadsheet-wide locale.

Does changing the locale change existing dates?
It changes the spreadsheet’s regional defaults and may affect how dates are displayed or interpreted, but cells with explicit formatting can behave differently from cells using default formatting. Review the existing values and formats after saving, particularly if the data includes ambiguous dates.

Why does 03/04/2026 mean different dates to different people?
That numeric pattern is ambiguous: depending on the convention, it can mean March 4 or 3 April. The spreadsheet locale influences date conventions and input interpretation. A written month or year-first format is clearer for a mixed audience.

Can I make every new Google Sheets file use the same date format?
The locale is set for each spreadsheet. New files may reflect your account or regional defaults, but changing one existing file’s locale does not set a universal personal date format for all files. For a reusable layout, start from a copy of a spreadsheet that already has the locale and cell formatting you want.

Will a custom date format change the date used in calculations?
No, when the cell contains a recognized date value, a custom format changes how it is displayed, not the date itself. If the cell contains text or was interpreted as the wrong date, formatting alone will not make its underlying value correct.

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.