Excel 2010 - change US dates to UK format
date-format, excel
Solution
Another solution without using a formula:
- Select the relevant columns
- Choose Data → Text to Columns…
- Select “Delimited” and click Next
- Untick all delimiters and click Next
- Select data column format “Date: MDY” and click Finish
The dates should now be converted to UK dates.
Problem
I have imported a CSV file with 2 long columns of dates. These dates are in the US format `Aug/28/2013` and I want them to be in the standard UK `dd/mm/yyyy` format. I have tried formatting the cells as US dates and then converting them to number-only formats, and various other permutations within the Date format box, but with no success. Can anyone rid me of these awful US dates please?