title: Excel 2010 - change US dates to UK format
body: <p>I have imported a CSV file with 2 long columns of dates. These dates are in the US format <code>Aug/28/2013</code> and I want them to be in the standard UK <code>dd/mm/yyyy</code> format.</p>
  
  <p>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. </p>
  
  <p>Can anyone rid me of these awful US dates please?</p>