title: Date format dd:mm:yy:hh:mm:ss to a dd/mm/yy hh:mm:ss
body: <p>I want to use VBA to convert the date stored on a file in the format <code>dd:mm:yy:hh:mm:ss</code> to something usable for sorting in excel using VBA to process files.  I can't find anything that is compact.  I have tried text to columns and then combine the values separated out back into a date and a time but this is cumbersome and slow for big data files.</p>
  
  <p>Anyone know a quick method that can be used??</p>