Google Sheets Australian Date Format: How to Set It Up

To use Australian dates in Google Sheets, set the spreadsheet locale to Australia through File > Settings > General > Locale, then choose Australia and save. Australian dates are commonly written day/month/year, such as 25/04/2026 for 25 April 2026; you can also apply a matching format to selected cells with Format > Number.

What the Australian date format means

In everyday Australian usage, the day comes before the month. A short date such as 3/7/2026 normally means 3 July 2026, not March 7. That order is the main difference to watch when sharing dates with people who use month/day/year conventions, particularly in the United States. When the day is 12 or lower, a date like 05/06/2026 can be misread without context.

For a spreadsheet, the key distinction is between a date’s value and its display format. A real date in Sheets is stored as a date value that can be sorted, filtered, used in calculations and displayed in different ways. The cell might show 25/04/2026, 25 Apr 2026 or Saturday, 25 April 2026 while representing the same date. By contrast, text that merely looks like a date may not behave as a date in formulas or sorting.

Setting the locale helps Sheets interpret new entries and choose regional defaults. Choosing a date display format separately gives you control over how existing date values look. For a reliable Australian-style sheet, it is often worth doing both.

Set the spreadsheet locale to Australia

The locale is a spreadsheet-level setting in Google Sheets in a web browser. It is not the same as the language of your Google account or the language used for the menus. To change it:

Open the spreadsheet and select File > Settings.
On the General tab, find Locale and select Australia.
Select Save settings. Sheets may reload the spreadsheet with the updated regional settings.

The locale affects regional defaults across the spreadsheet, including date, number and currency conventions. It can therefore change more than the order used for dates. For example, number separators and the default currency presentation may differ from those used under another locale. If the file is shared, consider whether Australia is appropriate for the whole spreadsheet rather than only for your own view.

Changing the locale does not magically repair every date already in the file. A stored date value remains a date value, though an automatically formatted cell may display differently under the new locale. A custom format may continue to show the pattern it was given. Text strings are still text: changing the locale does not reliably convert a pasted string such as 04/05/2026 into the date you intended.

Apply day/month/year to a range

After changing the locale, select the cells you want to format. Use Format > Number > Date for a standard date presentation, or choose Format > Number > Custom date and time to specify the exact appearance. In the custom-format dialog, arrange the day, month and year components in that order. A pattern such as dd/mm/yyyy gives a two-digit day, two-digit month and four-digit year; for example, 3 July 2026 appears as 03/07/2026.

You can use a shorter pattern if that fits the sheet’s purpose. d/m/yy displays the same example as 3/7/26, while a pattern using a written month can make a date easier to scan. Choose a four-digit year for records where ambiguity matters, such as invoices, bookings or project deadlines. After applying a format, widen the column if the displayed date appears as a row of hash marks; that usually means the column is too narrow, not that the date has disappeared.

Formatting a range is useful when a sheet already contains valid date values but shows them inconsistently. Select the whole date column, apply the chosen format once, and new values in that range will generally follow its formatting. If you have a header or notes in the column, select only the data cells so the format does not affect unrelated content.

Enter dates without ambiguity

With Australia selected as the locale, entering a date in day/month/year order is more natural for an Australian dataset. Still, ambiguous short entries can be risky if the spreadsheet has recently been changed, is being edited by people in different regions, or receives copied data from another system. Include a four-digit year where possible. A date such as 25/04/2026 is unambiguous under common day/month and month/day conventions because 25 cannot be a month.

For dates where both the day and month are 12 or lower, make the intended order clear in the column heading or use a written month in documentation. For instance, 05/06/2026 could mean 5 June or May 6 depending on the convention. A display such as 5 Jun 2026 is easier for a human reader to interpret, though the underlying value is still what makes it usable in calculations.

Keep dates in a consistent column rather than combining them with labels such as “Due 5 June” in the same cell. Consistency makes sorting, date filters, charts and date-based calculations more dependable. If you need to show both a date and explanatory text, use a separate notes column.

Importing, pasting and text that looks like a date

Data copied from a website, CSV file or another spreadsheet can arrive as text, even when it looks exactly like an Australian date. One clue is that changing the cell’s number format has no effect. Another is that the value may align or sort differently from dates in the same column, although alignment can be changed manually and is not proof by itself. A genuine date should respond to date formatting and usually sort in chronological order.

When importing a CSV, check the import preview and the spreadsheet locale before relying on ambiguous date strings. If the source uses month/day/year, simply setting the destination locale to Australia does not make the source’s intended order obvious. A string such as 04/05/2026 could be interpreted differently by different systems. Consult the source’s documentation or export settings, then convert the data based on the confirmed source order rather than guessing.

If pasted entries remain text, one practical approach is to correct or re-export them in an unambiguous form, then paste or import them again into a range configured for dates. You can also use Data > Split text to columns when the source has separate date components in one delimited field, but splitting only separates text; it does not by itself guarantee that the resulting parts become valid dates. Check a few converted rows before using the whole dataset.

A common misconception is that applying a date format converts any date-looking text into a date. Number formatting changes how numeric date values are displayed; it cannot always interpret arbitrary text. If formatting appears to do nothing, investigate the cell’s contents and the source format before repeatedly choosing new display patterns.

Locale versus a custom date format

Locale and cell formatting solve related but different problems. Locale sets regional defaults and influences how Sheets interprets entries. A cell format controls the visual presentation of values in the selected cells. For a workbook intended for Australian users, Australia is a sensible locale. For a sheet shared internationally, a custom format can make a particular column clear without changing regional defaults for the entire spreadsheet.

Neither choice is a substitute for clear data. A custom format can make a valid date look Australian, but it does not necessarily change how an ambiguous text entry was originally interpreted. Conversely, a spreadsheet set to Australia may still contain text imported from a source using another convention. Check the value and its meaning, not just the characters visible on screen.

When sharing a sheet, mention the date convention in a header or note, especially if dates are central to decisions or deadlines. A heading such as “Date (DD/MM/YYYY)” can prevent readers from assuming a different order. For data exchanged between systems, an unambiguous representation such as 2026-04-25 can be helpful, provided the receiving system supports it and the team agrees on that convention. It is not the usual short Australian display, but it avoids confusing day and month order.

Fix common Australian date problems

The date displays month first: Select the cells and apply a day/month/year pattern through Format > Number > Custom date and time. Check the spreadsheet locale as well if new entries are being interpreted unexpectedly.
Changing the format has no effect: The cell may contain text rather than a date value. Verify the source data and convert it using the source’s known date order.
The date changes to another day or month: The original entry may have been ambiguous and parsed under a different locale. Confirm the intended date with the source; formatting cannot undo a mistaken interpretation on its own.
The year appears as two digits: Choose a custom pattern with a four-digit year, such as dd/mm/yyyy, if the dialog offers that component arrangement.
Dates sort incorrectly: Text entries may be mixed with real dates, or the column may contain inconsistent formats. Check several cells and standardize them as date values before sorting.
Hash marks appear: Expand the column width or use a shorter display format. The underlying date may still be intact.

When correcting a large imported column, make a copy of the original data first. Test the proposed conversion on a small sample containing dates with day values above 12, dates where both components are 12 or less, and any blank or malformed entries. Those test cases can reveal an incorrect assumption before it affects the full dataset.

Frequently Asked Questions

How do I change Google Sheets to Australian date format?
Choose File > Settings > General > Locale, select Australia, and save. To control how a particular range appears, select it and choose Format > Number or Custom date and time.

Is the Australian date format DD/MM/YYYY?
Day/month/year is the customary Australian order. A common spreadsheet display is DD/MM/YYYY, such as 25/04/2026, but the precise display can vary: a sheet may omit leading zeroes or show a written month.

Will changing the locale change existing dates?
It can change how automatically formatted date values are displayed and how new entries are interpreted. It does not reliably convert text that looks like a date, and it does not resolve the intended meaning of an ambiguous value already entered.

Why are my Australian dates still showing as US dates?
The selected cells may have a custom month-first format, or the entries may have been interpreted before the locale was changed. Apply a day/month/year cell format and verify that the cell contains the intended date value rather than ambiguous text.

Can I use Australian dates without changing the whole spreadsheet locale?
Yes. Select the relevant cells and set a custom day/month/year format. This changes their display, while the spreadsheet’s regional defaults remain governed by its locale.

Does Google Sheets store dates as text?
Valid dates are stored as date values that can be formatted and used in date operations. A pasted string that merely resembles a date may remain text, so check imported data before relying on sorting or calculations.

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.