title: Convert text YYYY-MM-DD HH:MM:SS to Excel date
body: <p>I have a spreadsheet in Excel where in column, for example, B at the cell B5 and down there is a date entered in text format as YYYY-MM-DD HH:MM:SS. I want to convert it in a such way that Excel will be able to recognize it as date, because then I need to use filters and so on.</p>
  
  <p>I found <a href="https://superuser.com/questions/409896/how-do-i-enter-dates-in-iso-8601-date-format-yyyy-mm-dd-in-excel-and-have-exc?rq=1">this question</a> and tried to do it as follows: go to Format Cells, select Date Category, change my locale to Australia, select YYYY-MM-DD, but it doesn't work.</p>
  
  <p>Can anybody help me to convert all text dates in a selected column to Excel dates? Hours, minutes and seconds aren't very important.</p>