title: How to convert a DB2 date-time string into an Excel Date
body: <p>I'll regularly get an extract from a DB/2 database with dates and timestaps formatted like this:</p>
  
  <pre><code>2002-01-15-00.00.00.000000
  2008-01-05-12.36.05.190000
  9999-12-31-24.00.00.000000
  </code></pre>
  
  <p>Is there an easier way to convert this into the Excel date format than decomposing with substrings?</p>
  
  <pre><code>DB2date = DateValue(Left(a, 4) + "/" + Mid(a, 6, 2) + "/" + Mid(a, 9, 2))
  </code></pre>
  
  <p>thanks for your help!</p>