How to Change Date Formats from US to UK in Google Sheets

Learn how to quickly switch dates from US MM/DD/YYYY to UK DD/MM/YYYY format in Google Sheets with simple formatting steps.

578 views

To change dates from US to UK format in Sheets, highlight the cells with dates, go to Format > Number > More Formats > More Date and Time Formats. Choose the UK date format (DD/MM/YYYY) and click Apply.

FAQs & Answers

  1. How can I set a default UK date format in Google Sheets? To set a default UK date format, you can change the spreadsheet locale to the United Kingdom via File > Settings > Locale, which will apply UK date formats by default.
  2. Why does Google Sheets show dates differently than my local format? Google Sheets uses the spreadsheet locale to determine date formats, so if the locale is set to the US, dates appear in MM/DD/YYYY format; changing locale adjusts this.
  3. Can I convert existing US-formatted text dates to UK format in Sheets? Yes, by converting text dates to date objects using DATEVALUE and then formatting the cells to UK style, you can properly display UK dates.

Watch More

If you found this tutorial helpful, explore more Google Sheets tips such as customizing number formats, applying conditional formatting, and using date functions to boost your productivity and data management skills.

  1. Step-by-Step Guide: Sorting Dates in UK Format in Excel Learn how to sort dates in UK format (DD/MM/YYYY) in Excel with this easy guide.
  2. How to Highlight Expiry Dates in Excel Using Conditional Formatting Learn how to easily highlight expiry dates in Excel with conditional formatting to stay organized and on top of deadlines.
  3. How to Format Hours and Minutes in Google Sheets: A Simple Guide Learn how to easily extract and display hours and minutes in Google Sheets with formulas.