• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar

Tachytelic.net

  • About Me
    • Privacy Policy
  • Sco Openserver
    • Sco Unix Support
    • SCO Openserver Installation ISOs
    • SCO Openserver Binaries
  • Get in touch

Convert US Dates to UK Dates in Excel

February 13, 2019 by Paulie 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:

https://www.tachytelic.net/wp-content/uploads/Excel-Convert-US-Dates-to-UK-Format.mp4

 

Related

Filed Under: How To Tagged With: Excel

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Copyright © 2019 · eleven40 Pro on Genesis Framework · WordPress · Log in