Google Sheets Logo

If yous need to work with some other date format in Google Sheets, it's easy to change your Sail's default format to lucifer the standard in any location. Here's how.

Imagine you're working with a Sheet from a U.G. client. The U.G. uses the "DD/MM/YYYY" format, meaning that the twenty-four hours value comes showtime, followed past the calendar month and the twelvemonth. But if you lot're from North America, you lot likely use a different format, such equally "MM/DD/YYYY." You'll want your spreadsheet to match that format so that the dates make sense to you.

An example of UK and US date formats in Google Sheets.

Google Sheets uses the typical conventions of your region to make up one's mind whether the day or the calendar month comes showtime in a date timestamp. To change the date format for a particular spreadsheet, you'll need to switch the "Locale" setting to that of the area with the date format that you'd adopt to use.

To practice this, open your spreadsheet in Google Sheets and printing File > Spreadsheet Settings.

To change the locale settings in Google Sheets, press File > Spreadsheet Settings.

From the "Locale" drop-downwardly menu, select an alternative location. For example, setting the locale to "United Kingdom" volition switch your spreadsheet to the "DD/MM/YYYY" format and set the default currency to GBP, and and so on.

To change the default appointment format to "MM/DD/YYYY," set the Locale value to "United States" or some other region that uses that format. To save the change, click "Save Settings."

In the "Settings For This Spreadsheet" menu, change the "Locale" value to another location with a different date format to your own, then press "Save Settings" to save the changes.

Subsequently irresolute your locale, any dates already entered into the Sheet will exist automatically translated to the date format of the locale you chose, and whatever appointment values that you insert later on this point volition match the conventions of that location. And remember: This change only applies to this ane spreadsheet.

In some cases, y'all may need to manually alter the number format for some previously entered dates if they aren't automatically recognized. To practice so, select those cells and choose Format > Number > Date from the menu.

To set any existing date values to match the new date formatting, select the cells, then press Format > Number > Date to apply the new date format.

This will apply the spreadsheet's new default engagement format to the existing data, ensuring that the aforementioned format is used across your spreadsheet.

If yous want to switch the spreadsheet'southward locale dorsum when you're washed (before, say, handing information technology off to someone else in another region), visit File > Spreadsheet settings again and choose the locale with the desired date format.

RELATED: The Beginner's Guide to Google Sheets