title: How to change MM/DD/YYYY to DD/MM/YYYY
body: <p>I have imported a CSV file to the spreadsheet that includes columns with Dates and timestamp (Columns D,E,K,L) and I'm currently facing 2 problems with these columns. </p>
  
  <ol>
  <li><p>Some rows are formatted as text/string and I can't seem to change it to date format. I tried manually changing it via format>number>datetime but it remains the same.</p></li>
  <li><p>the format of the date is being read incorrectly by spreadsheet. For example,  5/11/2018 is being read as May 11, 2019 but if you try to review the spreadsheet, it should be read as November 5, 2018. I tried playing with the format and spreadsheet settings to no avail. </p></li>
  </ol>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1qZq0cv0ux1_Z6KyoihRWorSuQoaH-5eGWwLIAqFEmZg/edit?usp=sharing" rel="nofollow noreferrer">Spreadsheet Sample</a></p>
  
  <p>I'd appreciate any inputs.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <ol>
  <li><p>For Column D &amp; E, I have already converted all rows to Date but the problem persists where in some rows are being read as DD/MM/YYYY and some rows MM/DD/YYYY. This creates date discrepancy when I try to make data visualization using these data:( </p></li>
  <li><p>I am unable to convert all rows in Column L to date format. Some rows are still being read as text/string.</p></li>
  </ol>