• Upgrade your Internet Experience
  • Sign in
  • Microsoft.com
  • United States (English)
    Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Italia (Italiano)Россия (Русский)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)香港特别行政區 (中文)
 
 
Microsoft Developer Network
 
 
Home
 
 
Library
 
 
Learn
 
 
Downloads
 
 
Support
 
 
Community
 
 
Forums
 
 
 
Microsoft Developer Network > Forums Home > Microsoft Visual Studio 2010 Beta 1 Forums > Visual Basic Language > Excel Serial date conversion
Ask a questionAsk a question
Search Forums:
  • Search Visual Basic Language Forum Search Visual Basic Language Forum
  • Search All Microsoft Visual Studio 2010 Beta 1 Forums Search All Microsoft Visual Studio 2010 Beta 1 Forums
  • Search All MSDN Forums Search All MSDN Forums
 

AnswerExcel Serial date conversion

  • Thursday, November 30, 2006 4:17 PMCoroebus Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Vote As Helpful
    0

    Hello,

    how to convert an excel serial date as 39051,4387847222 in a datetime as 30/11/06 10:31:51 2549 using vb.net?

    thanks

    • ReplyReply
    • QuoteQuote
     

Answers

  • Thursday, November 30, 2006 4:29 PMDMan1ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Vote As Helpful
    0

    Dim d As Date = Date.FromOADate(39051.4387847222)

    MessageBox.Show(d.ToString)

    • ReplyReply
    • QuoteQuote
     

All Replies

    Need Help with Forums? (FAQ)
     
    © 2009 Microsoft Corporation. All rights reserved.
    Terms of Use
    |
    Trademarks
    |
    Privacy Statement