title: I need to change format of a date column from D-M-Y to Y-M-D in excel
body: <p>I was trying to import a CSV file to my <code>phpmyadmin</code>.  Then my date field had values as <code>0000-00-00</code> since both date formats were different. I changed the CSV date-format to the format in the database. I have 5000+ data in my CSV. but only a few dates change to the format I chose. Remaining still in the old format </p>
  
  <p>I went to <code>Format cells</code>, selected date, changed to Uk and selected the desired date format. But only a few dates change to the format I chose. Remaining still in the old format</p>