Tachytelic.net

Convert US Dates to UK Format in Excel

by Leave a Comment

If you have a column of dates in Excel that are in US format, it is easy to convert them to UK format. Simply follow these steps:

  1. Select the column containing the US Dates:
    Image showing selection of column of US format dates in Excel
  2. From the Data Ribbon, Choose “Text to Columns”:
    Image showing the data Ribbon on Excel with the Text to Columns function highlited
  3. Choose “Delimited” from the Text to Columns Wizard, then click next.
  4. Untick all the delimiters.
  5. In the column data format area, choose “Date” and select “MYD” from the drop down menu:
    Image showing Excel Text to Columns Column data format. To convert US dates to UK dates
  6. Excel will now recognise the column as dates and you use format cells to select the UK date format, or any format that suits you.

How is a video demonstration of how to convert US Dates to UK Format:

 

Reader Interactions

Leave a Reply