title: VBA \ VB6 - Convert number to DATE
body: <p>VBA \ VB6 - 
  I have a long number: <code>20141202153026</code> </p>
  
  <p>which should be converted to a date\time (just to be turned back to a properly formatted date string) as:</p>
  
  <pre><code>2014/12/02 15:30:26
  </code></pre>
  
  <p>Using <code>CDate()</code> just isn't cutting it.</p>
  
  <pre><code>Format$("20141202153026", "dd/mm/yy hh:mm:ss")
  </code></pre>
  
  <p>Also seem to fail.
  Need a direction here.</p>
  
  <p>EDIT: i used jac's solution and it worked great.
  One thing to remember though is to cast the result back to date with cDate() - to make sure locale settings kick in and arrange the year and the month at their right positions DD/MM/YYYY</p>
  
  <pre><code> CDate(Format$("20141202153026", "####/##/## ##:##:##"))
  </code></pre>