Change Google Sheets Date Format to Australia

To use Australian dates in Google Sheets, open the spreadsheet in a browser and choose File > Settings. Under General, set Locale to Australia, then save the settings. Australian-style dates normally put the day before the month, such as 5/11/2026 for 5 November 2026.

Set the spreadsheet locale to Australia

The locale setting is the main option when you want a whole Google Sheets file to use Australian conventions. It affects more than how dates look: it can also change default number, currency, and other regional formatting. The setting belongs to the spreadsheet, so it is not simply a preference for the browser or for your Google account.

Open the spreadsheet in Google Sheets in a web browser.
Select File > Settings.
In the settings window, open the General tab if it is not already selected.
Choose Australia from the Locale list.
Select Save settings. If prompted, allow the spreadsheet to reload.

After the change, check a date cell and try entering a new date in a blank cell. A value such as 5/11/2026 should be understood as 5 November 2026 under Australian day/month/year convention. Because the locale applies to the spreadsheet rather than only your view, collaborators opening the same file can be affected too. Tell collaborators about the change if they have been entering dates using a different convention.

What the locale changes—and what it does not

Locale and cell formatting are related but distinct. The locale sets regional defaults and influences how Sheets interprets some entered values. A cell’s number format controls how an already stored value is displayed. Changing the locale is useful for making a file consistent overall, but it does not guarantee that every cell will show the exact date pattern you want.

For example, a date cell may have a custom format that was applied before the locale changed. It can keep that format rather than adopting the display you expect. Conversely, a date may be stored correctly but look unfamiliar because its cell format differs. The underlying date value and its visible representation are not the same thing: changing a display format does not, by itself, change the date represented by a genuine date value.

Locale is also not the same as time zone. A spreadsheet can use Australia as its locale while having a separately selected time zone. Time zones matter for time and date-time values; choosing a time zone does not switch dates to day/month/year formatting.

Format selected cells as day/month/year

If you only need Australian-style display in a particular column or range, you can format those cells without changing the locale for the entire spreadsheet. Select the cells, then choose Format > Number > Custom date and time. In the date-format controls, choose or enter a pattern such as dd/mm/yyyy, then apply it. The result displays a two-digit day, a two-digit month, and a four-digit year, for example 05/11/2026.

To show shorter dates, use a pattern such as d/m/yyyy, which can display 5/11/2026 without leading zeroes. A pattern such as d mmm yyyy gives a more readable result, for example 5 Nov 2026. The abbreviated month can be helpful in reports where a numeric date might be misread. The exact appearance of month names can depend on the spreadsheet’s locale.

Use dd/mm/yyyy when consistent two-digit day and month fields are important.
Use d/m/yyyy when compact numeric dates are preferable.
Use a month name, such as d mmm yyyy, when you want to make the month unmistakable.

Formatting a range changes how valid date values appear; it does not convert ordinary text into dates or repair a date that was interpreted incorrectly. If a cell remains unchanged after applying a date format, check whether Sheets recognizes its contents as a date value.

Enter dates without ambiguity

Dates such as 5/11/2026 are clear to someone familiar with Australian conventions, but they are easy to misread in a spreadsheet shared internationally. In a month/day/year system, the same numbers could mean May 11. When a day and month are both 12 or lower, the digits alone do not reveal which convention was used. A spreadsheet locale helps determine how new entries are interpreted, but it cannot tell you what another person intended when they supplied an ambiguous value.

For shared records, reduce uncertainty at the point of entry. Use a date picker where practical, label the column with the intended convention, and consider displaying dates with month names in reports. For example, 5 Nov 2026 is less ambiguous than 05/11/2026. If you exchange data with people in other regions, agree on a convention before they enter dates rather than relying on them to infer it from the sheet.

Be especially careful with dates typed before changing the locale. A date entered as 4/5/2026 might already have been interpreted as April 5, or as 4 May, depending on the settings in force at the time. Applying an Australian display format afterward may simply show that stored date in a new style; it may not reinterpret the original intended date.

Check and correct dates that look wrong

If a date appears to have the wrong month or day, first distinguish a display problem from an incorrect stored value. Select the cell and inspect its displayed value and number format. Try applying a clear format that includes a month name. If the result is 4 Apr 2026 but you expected 5 April, the value itself may be wrong rather than merely displayed in the wrong order.

A common misconception is that changing the locale or choosing dd/mm/yyyy converts every existing date into the intended Australian date. It does not reliably fix values that were already parsed the wrong way, and it does not turn text into real dates. For a small number of incorrect entries, verify each one against the original source and re-enter it as the intended date. For a large imported dataset, preserve a copy of the original data, identify which entries are ambiguous, and confirm the source convention before changing values in bulk.

Text can be another cause. If a cell contains characters that look like a date but are stored as plain text, changing the number format may have no visible effect. Check the source data and import method, and test any proposed correction on a copy or a few representative rows first. Avoid assuming that left or right alignment proves a cell’s data type: alignment can be changed manually, so it is only a clue, not a dependable test.

Import dates and work with shared files

When you paste or import dates from another system, the source may use a different convention from the spreadsheet. A column containing 03/04/2026 could mean 3 April or March 4. If Sheets interprets the value during import or pasting, changing the locale afterward may not recover the sender’s intended meaning. Check the source system’s date convention and compare a few known records before relying on the imported column.

For a one-off import, keep the original file or a separate copy of the imported column until you have confirmed that the dates are correct. For recurring imports, document the expected format for whoever prepares the data and check that the same convention is used each time. Using month names in a handoff or report can make a review easier, even if the working sheet stores genuine date values.

Because locale is a spreadsheet-level setting, changing it can affect collaborators’ work and other regional defaults, not just one date column. If only one part of a shared workbook needs Australian display, formatting that range may be less disruptive. If the whole workbook is intended for Australian use, set its locale and communicate the change so people know how to enter new dates.

Google Sheets locale compared with Excel

Google Sheets stores its locale setting with the spreadsheet and lets you change it through File > Settings. Excel handles regional date interpretation and display differently: date formats are stored with cells, while regional defaults and input behavior can depend on the Excel version and system settings. As a result, changing an Excel setting is not a direct substitute for changing a Google Sheets locale.

If a workbook moves between Excel and Sheets, inspect dates after opening or importing it. A date may retain a recognizable underlying value but display differently, and text dates may be interpreted according to the receiving environment. For important records, use an unambiguous display in the shared version and confirm dates against the source rather than assuming the two applications will parse every text entry alike.

Frequently Asked Questions

How do I change Google Sheets from US dates to Australian dates?
Choose File > Settings, set Locale to Australia under General, and save. The locale affects the spreadsheet as a whole, not just one selected column.

What is the Australian date format in Google Sheets?
The usual numeric order is day/month/year, such as 5/11/2026 for 5 November 2026. You can display leading zeroes with a format such as dd/mm/yyyy.

Will changing the locale fix dates already entered incorrectly?
Not necessarily. It can change regional defaults and how dates are displayed, but it does not reliably correct a value that was interpreted as the wrong day and month. Verify ambiguous entries against their source.

Can I change the date format for just one column?
Yes. Select the column or cells and choose Format > Number > Custom date and time. Apply a pattern such as dd/mm/yyyy without changing the spreadsheet’s overall locale.

Why does changing the format not affect a date-looking cell?
The contents may be text rather than a recognized date value, or the cell may not have been selected. A number format changes the display of date values; it does not automatically convert text or correct an incorrectly interpreted date.

Does setting the locale to Australia change the time zone?
No. Locale and time zone are separate spreadsheet settings. Locale controls regional conventions such as date and number formatting, while time zone settings affect time-related values.

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.