<p>Hello,</p> <p>how to convert an excel serial date as 39051,4387847222 in a datetime as 30/11/06 10:31:51 2549 using vb.net?</p> <p>thanks</p>© 2009 Microsoft Corporation. All rights reserved.Thu, 19 Jun 2008 00:15:52 Zf8870029-4448-48cf-8ae9-71608f0195abhttp://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/f8870029-4448-48cf-8ae9-71608f0195ab#f8870029-4448-48cf-8ae9-71608f0195abhttp://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/f8870029-4448-48cf-8ae9-71608f0195ab#f8870029-4448-48cf-8ae9-71608f0195abCoroebushttp://social.msdn.microsoft.com/Profile/en-US/?user=Coroebus<p>Hello,</p> <p>how to convert an excel serial date as 39051,4387847222 in a datetime as 30/11/06 10:31:51 2549 using vb.net?</p> <p>thanks</p>Thu, 30 Nov 2006 16:17:59 Z2006-11-30T16:42:40Zhttp://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/f8870029-4448-48cf-8ae9-71608f0195ab#c333f5c9-ce85-49ce-b234-7481e186a940http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/f8870029-4448-48cf-8ae9-71608f0195ab#c333f5c9-ce85-49ce-b234-7481e186a940DMan1http://social.msdn.microsoft.com/Profile/en-US/?user=DMan1<font size=2> <p></font><font color="#0000ff" size=2>Dim</font><font size=2> </font><font color="#800080" size=2>d</font><font size=2> </font><font color="#0000ff" size=2>As</font><font size=2> </font><font color="#0000ff" size=2>Date</font><font size=2> = </font><font color="#0000ff" size=2>Date</font><font size=2>.</font><font color="#800080" size=2>FromOADate</font><font size=2>(39051.4387847222)</p> <p></font><font color="#800080" size=2>MessageBox</font><font size=2>.</font><font color="#800080" size=2>Show</font><font size=2>(</font><font color="#800080" size=2>d</font><font size=2>.</font><font color="#800080" size=2>ToString</font><font size=2>)</p></font>Thu, 30 Nov 2006 16:29:17 Z2006-11-30T16:42:40Z