Converting DMY Dates to YMD Format in Excel

01/02/2022 :

Excel is a powerful tool that allows you to store and manipulate data with ease. One common problem that users encounter is converting dates from the dd/mm/yyyy format to the yyyy/mm/dd format. In this article, we will show you how to convert dd/mm/yyyy dates to yyyy/mm/dd format in Excel, step-by-step.

  • Select the column of dates
  • Under DATA, select “Text to Columns”
  • Select Delimited – Next
  • Untick ALL delimiters – Next
  • Select column format “Date: DMY” – Finish (Note: this data format should be what the dates are currently in, not what you want them to be)
  • The text will now be recognised by Excel as a date and appear as right-justified in the column
  • Right-click the still highlighted column (or select it again) and open Format Cells and change date format to the style you require