How to Change the date format in Google Sheets to another locale

Last updated Jun 17, 2022

The Locale automatically adjusts the date format in Google Sheets according to your location. For instance, if you work from the United States, a date like 06-Aug-2020 would be written as 8/6/2020. If the file is from another country, you can change it according to your locale. It's vital to remember that Locale doesn't change the language of your Google Sheets.  In this article, we are going to learn how to change your  date format to another locale

How to change your locale  and time zone 

To change your time zone and locale, simply follow the following simple steps

Step 1:  On the Google sheets menu, click on “File”

Change the date format in Google Sheets

 

Step 2: From the “File” submenu, select settings

Change the date format in Google Sheets2

 

Step 3:  Now, Go to  the General tab to  find the  Locale settings, and  from the provided  choices, select  the desired location from the list

Change the date format in Google Sheets3

 

Step 4: Now, you can change your locale as well as your time zone based on your needs.

Change the date format in Google Sheets4

 

Step 5: Once you have selected your  locale and time zone,  click on “save settings. 

Change the date format in Google Sheets5

Your date, locale, and time zone will now be changed.

Conclusion

When working with Google Sheets, it is obvious that you will have to use dates. You can format these dates for your preference and convenience. This article has taken us through the steps that you need to follow to change your locale and timezone

 

Keywords: Google Docs, Google Sheets, Change the date format in Google Sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

35 Views