Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine number format of excel cell
hi,
I am writing a program to read data from excel sheet. while reading a cell which contains a date, it returns a number. Eg:Suppose cell A1 contains the following date : February 13, 1900 The Range object that refers the cell, returns to me 44 as value. By googling, I found the method to convert it back to the date format. they are : Application.WorksheetFunction.Text(value, "mm/dd/yyyy") or DateTime.FromOADate(double d) But my question, is there any way i can determine if the cell has DATE type. I can get the format of the date by using Range.NumberFormat. But I need to first know, if the cell is DATE type for that? Any help would be appreciated. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine number format of excel cell
Why not read the .Text property instead of the .Value property of the range.
Or Public Function GetVarType(InputCell As Range) As Long 'Check the help for the meaning of the return values 'But a Date will return # 7 GetVarType = VarType(InputCell.Value) End Function NickHK "James Bond" wrote in message oups.com... hi, I am writing a program to read data from excel sheet. while reading a cell which contains a date, it returns a number. Eg:Suppose cell A1 contains the following date : February 13, 1900 The Range object that refers the cell, returns to me 44 as value. By googling, I found the method to convert it back to the date format. they are : Application.WorksheetFunction.Text(value, "mm/dd/yyyy") or DateTime.FromOADate(double d) But my question, is there any way i can determine if the cell has DATE type. I can get the format of the date by using Range.NumberFormat. But I need to first know, if the cell is DATE type for that? Any help would be appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct, multiple if, some same cell, determine number of rows | Excel Worksheet Functions | |||
How to determine the cell contain number only? | Excel Discussion (Misc queries) | |||
How do I determine the number of cell formats in this workbook | Excel Discussion (Misc queries) | |||
Determine number of lines of text within a cell | Excel Programming | |||
HOW-TO: Determine if a cell contains a number vs. formula vs. reference | Excel Programming |