Google Sheets British Date Format: Set Dates to DD/MM/YYYY

To use British date format in Google Sheets, set the spreadsheet’s locale to United Kingdom under File > Settings > General > Locale, then select Format > Number > Custom date and time and apply a day/month/year pattern such as dd/mm/yyyy. The locale sets regional defaults; the custom format controls how selected date cells are displayed.

What British date format means in Google Sheets

In the UK, dates are commonly written day, month, year: 3 April 2025 appears as 03/04/2025. This order differs from the US month/day/year convention, where the same digits, 03/04/2025, mean March 4. That ambiguity is why a spreadsheet’s locale matters: it can affect how Google Sheets interprets dates that you type or import, not just how they look.

It is useful to separate two things: a date’s underlying value and its displayed format. Sheets stores recognised dates as numeric date values, which lets you sort them chronologically, calculate intervals and use them in date-based functions. A date format changes the way that value appears in a cell; it does not usually change the date itself. By contrast, text that merely looks like a date may not behave as a date in calculations or sorting.

Set the spreadsheet locale to United Kingdom

Locale is a spreadsheet-level setting. To set it in Google Sheets in a web browser:

Open the spreadsheet and choose File > Settings.
On the General tab, open the Locale menu and choose United Kingdom.
Choose Save settings. If prompted, allow the spreadsheet to reload.

This setting establishes regional defaults for the spreadsheet, including date and number conventions. It can also affect things such as the default currency and decimal or thousands separators. It does not necessarily make every existing date display as dd/mm/yyyy: a cell may already have a specific number format applied, so check the cells you care about after changing the locale.

Locale is not the same as language. It does not translate text already in the file, and Google Sheets has a separate setting for function language. Nor is locale the same as time zone. The spreadsheet’s time zone is configured in the same general settings area, but it matters particularly for time-dependent values and timestamps rather than for choosing day/month order.

Apply a British date display to cells

To format dates that are already in the sheet, select the cells or column, then choose Format > Number > Custom date and time. In the formatting dialog, choose or arrange day, month and year components in that order. A pattern such as dd/mm/yyyy displays a two-digit day, two-digit month and four-digit year—for example, 3 April 2025 appears as 03/04/2025. Apply the format to finish.

The shorter pattern d/m/yyyy does not add a leading zero to the day or month, so the same date may appear as 3/4/2025. A pattern using a two-digit year can save space, but it is less explicit: 03/04/25 omits the century and is easier to misread in records that may be used years later. For invoices, schedules and shared datasets, a four-digit year is usually clearer.

You can also use Format > Number > Date for a standard date style, but the exact appearance can depend on the spreadsheet’s locale and applied formatting. Choose the custom option when you need a specific, consistent layout. Formatting an entire column is convenient for future entries, though it does not convert any existing text values into dates.

Enter dates without ambiguity

Once the spreadsheet uses a UK locale, entering a date such as 03/04/2025 is intended to mean 3 April 2025. In a spreadsheet using a US locale, the same input may mean March 4. This is not a cosmetic difference: if Sheets interprets the input incorrectly, changing the display format later can show the wrong date in British order while preserving the wrong underlying day and month.

For dates that will be copied between files or supplied by other people, avoid relying on an ambiguous string of digits. Use a clear written month, such as 3 Apr 2025, when entering dates manually, or establish the correct locale before importing or pasting date data. An ISO-style year-month-day date, such as 2025-04-03, is also much less ambiguous when exchanging data, but check how the receiving spreadsheet has parsed it rather than assuming every source handles it identically.

When a date is important, select the cell and inspect the formula bar or change its display temporarily to a format that makes the month clear. For example, a format with a spelled-out month distinguishes 3 April from March 4. This is a useful check after changing locale, pasting a list, or receiving a sheet from someone using different regional settings.

Fix dates that remain as text

A common problem is that cells continue to look unchanged after applying a British date format. One explanation is that the contents are text rather than recognised date values. Formatting affects date values, but it cannot reliably turn arbitrary text into a date. Text may have arrived from a CSV, a copied webpage, an export from another system or a file created with a different locale.

To diagnose the issue, format a cell with a clearly different date style and see whether its display changes. You can also try sorting a small test range by date and check whether the order is chronological. If text values sort alphabetically or refuse to respond to date formatting, they may need to be converted or re-imported using the correct regional settings. Keep a copy of the original data before making a bulk conversion, especially if the day and month could have been swapped.

When importing a CSV, review the import options and check the resulting dates before relying on them. If the source uses month/day/year but the sheet is set to UK order, some entries may be interpreted differently or left as text. A careful approach is to identify the source convention, import into a clean sheet, and verify representative dates from the beginning, middle and end of the range. Do not assume that changing the number format repairs an incorrect interpretation.

Understand what changing locale does to a shared sheet

Because locale belongs to the spreadsheet rather than to one cell or one person’s browser, changing it can affect the working defaults for everyone using that file. If collaborators enter dates using different conventions, agree on a single locale and communicate the expected input format. Otherwise, a user may type a date that looks valid but represents another day and month than intended.

Existing cells can have individual number formats, so the locale change may not visibly alter every date. Conversely, a date with a general or default format may display differently after a regional setting changes. Before changing locale in a busy shared workbook, consider making a copy and checking date columns, number separators and currency displays. The setting is useful for establishing consistent defaults, but it is not a substitute for reviewing data that has already been entered.

British dates in sorting, formulas and exports

When Sheets recognises values as dates, sorting them by date uses their underlying chronological values, not simply the left-to-right appearance of the digits. A column displayed as dd/mm/yyyy can therefore sort correctly from earliest to latest. If the entries are text, however, the apparent order may be wrong; for example, a text sort can place dates according to their characters rather than their calendar sequence.

Date formatting also does not change how date calculations work. A valid date can be used in date arithmetic or date functions regardless of whether it is displayed as 03/04/2025, 3 Apr 2025 or another style. If a formula gives an unexpected result, check whether its input cells contain recognised date values and whether those values were interpreted with the intended day and month. Changing the format alone cannot fix a mistaken input.

When sharing or exporting data, consider the software that will open it. A CSV file does not carry the spreadsheet’s full cell formatting and regional settings in the same way as a Google Sheets file. A recipient may interpret a date string according to their own application or locale. For data exchange, a clearly specified format or unambiguous written month can reduce confusion; for a polished report, verify the exported result in the destination program.

Google Sheets and Excel are not identical

The steps above are for Google Sheets in a web browser. Excel has its own regional and number-format controls, and menu names and behaviour vary between Excel versions and operating systems. A workbook exported from Sheets and opened in Excel may retain many date values and formats, but Excel can display or interpret them according to its own settings. If the file is shared across both applications, test a copy in the target program and confirm that dates remain in day/month/year order.

For a team that works across Sheets and Excel, the safest practice is to agree on a clear date convention, use real date values rather than pasted text where possible, and verify imported or exported records. Do not judge correctness only by the visible digits: 04/03/2025 can mean 4 March or 3 April depending on interpretation.

Frequently Asked Questions

How do I make Google Sheets default to UK dates?

Set the spreadsheet locale to United Kingdom through File > Settings > General > Locale, then save the settings. Apply a custom date format such as dd/mm/yyyy to columns that need a fixed appearance, since existing cell formats may override the locale’s defaults.

Does changing the locale change dates already entered?

Changing locale can affect default display and how future inputs are interpreted, but it does not safely correct a date that was previously parsed as the wrong day and month. Check important existing values after changing the setting, especially ambiguous dates such as 03/04/2025.

Why does dd/mm/yyyy not change my date?

The cell may contain text rather than a recognised date value. Number formatting applies to date values, not arbitrary text. Check the source and import settings, then convert or re-import the values carefully, preserving a copy of the original in case the source used a different date order.

Can I use British dates without changing the spreadsheet locale?

Yes. Select the relevant cells and apply a custom day/month/year format. That controls how recognised dates appear, but it does not establish UK parsing rules for new ambiguous entries across the spreadsheet. Use clear month names or confirm the input convention if you leave the locale unchanged.

Will a CSV keep my Google Sheets date format?

CSV is a plain-text format and does not preserve the spreadsheet’s full formatting settings. Date strings may be interpreted according to the receiving application’s locale. Check the exported file and tell recipients which date order it uses, or choose an unambiguous representation for data exchange.

What is the clearest British date format?

For most spreadsheets, dd/mm/yyyy is compact and makes the day-first order explicit when users know the convention. For documents shared internationally, a written month such as 3 Apr 2025 is even harder to confuse with a US-style date.

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.