title: Converting mmyy into a useable date
body: <p>My question is very similar to this problem, but for Excel: <a href="https://stackoverflow.com/questions/22566950/how-do-i-convert-mmyy-to-last-day-of-month-in-netezza">how do I convert mmyy to last day of month in netezza</a> or this one: <a href="https://stackoverflow.com/questions/5262109/create-a-date-from-credit-card-expire-in-mmyy-format">Create a date from Credit Card expire in MMYY format</a>.</p>
  
  <p>Essentially I have a column filled with dates that have been written as mmyy i.e.</p>
  
  <blockquote>
    <p>0215<br>
    0215<br>
    0215<br>
    0315<br>
    0315</p>
  </blockquote>
  
  <p>The column has been saved as the data type: "Special".  </p>
  
  <p>How do I convert this data into a useable format? I don't mind if we put it into <em>dd/mm/yyyy</em> and use the first or the last day of the month that's fine.  Is there an Excel function that I could use or is this something I would have to do in VBA and if so, how?</p>