How to Change Date Format in a Google Spreadsheet

Written by chris hoffman Google
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:


  1. 1

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

  2. 2

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

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

    Click the "Save Settings" button.

Tips and warnings

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

Don't Miss


  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.