We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

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.

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

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

  3. 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.

  4. Click the "Save Settings" button.

  5. 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.

Loading ...


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.

Loading ...