title: Excel: date formatting
body: <p>I downloaded a csv file with dates in one column. The dates are formatted dd/mm/yyyy, but when i open the file Excel auto formats the dates it recognises as an actual date and leaves dates it doesn't recognise as a text.</p>
  
  <p>So for example, 01-01-2010 would be 1 January 2010, but excel reads it as January 1 2010 and formats it as such. Something like 30-07-2010 is not recognised and is formatted as general text. </p>
  
  <p>So now I have groups of rows which are formatted to dates as dd/mm/yyyy and groups of rows that are simply xx-xx-xxxx.</p>
  
  <p>Is there any way that can I easily convert stuff like 30-07-2010 to something excel recognises as a date input?</p>
  
  <p>The file I have is downloaded and there is no way to select a file that formats dates as mm-dd-yyyy</p>
  
  <p>Thanks a lot!</p>