title: VBA convert string to date format
body: <p>I have a file with strings that are in the format YYMMDD. eg. 120216 (will always be in this format). </p>
  
  <p>I want to convert this into a date ideally in the format DDMMYY or DDMMYYYY.</p>
  
  <p>Has anyone come across a similar problem and how did they resolve it?</p>