NumberToDateTime Method

Converts the specified date-time serial number to an instance of System.DateTime.

[Visual Basic]
Overridable Function NumberToDateTime( _
   ByVal number As Double _
) As Date

[C#]
virtual DateTime NumberToDateTime( 
   double number
);

[C++]
virtual DateTime NumberToDateTime( 
   double number
) 

[C++/CLI]
virtual DateTime NumberToDateTime( 
   double number
) 

Parameters

number

The date-time serial number to convert.

Return Type

An instance of System.DateTime initialized with the converted date-time serial number.

Remarks

Dates and times are stored in worksheet cells as a date-time serial number.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbook Interface  | IWorkbook Members  | DateTimeToNumber Method  | Date1904 Property

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.