DISCOVER
×

How to Change Date Format in a Google Spreadsheet

Updated July 20, 2017

Google Docs contains a variety of Web productivity applications, including a spreadsheet, word processor and presentation program. When you type a date such as "August 1" into a cell on a Google spreadsheet, Google converts it to the "month/day/year" format. Google selects the format based on your location. If you want a different date format, such as "day/month/year," change the locale setting to a different country. You can change each spreadsheet's locale individually.

Open the spreadsheet by clicking its name on your Google Docs page.

Click the "File" menu at the top of the Google Docs spreadsheet and click "Spreadsheet Settings."

Click the box under "Locale" and select a locale by clicking it in the list. Select "United States" for month/day/year format or a country such as the United Kingdom for day/month/year format.

Click the "Save Settings" button.

Tip

You can change the default locale for all spreadsheets from the Google Docs settings page. Click the gear icon at the top-right corner of the Google Docs page and click "Documents Settings" to access it.

Cite this Article A tool to create a citation to reference this article Cite this Article

Resources

About the Author

Chris Hoffman is a technology writer and all-around tech geek who writes for PC World, MakeUseOf, and How-To Geek. He's been using Windows since Windows 3.1 was released in 1992.