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:
Easy

Other People Are Reading

Instructions

  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

Resources

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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