title: Excel - Convert date from yymmdd to dd/mm/yy
body: <p>I have an Excel file which is exported from a Access database. </p>
  
  <p>I have <code>25000</code> records and I will need to replace all of them.</p>
  
  <p>The date column is not formatted (yymmdd). I need to change the date format from yymmdd to dd/mm/19yy. For the <code>yy</code> I need to add a constant value <code>19</code> in front of it so it would be <code>19yy</code>.</p>
  
  <p><strong>I have only 1 date column per row</strong></p>
  
  <p>Is there any way to convert all the <code>25000</code> record's column formatted in <code>yymmdd</code> to <code>dd/mm/19yy</code> in a few clicks?. Thank you</p>