Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
My code imports data from Excel spreadsheet. The line of code is: oExcelWS.Cells(Row, Column).Value All is fine when cell contains text or number, however one cell contains time in 24 hrs format" for example 22:35 When reading that cell value the result is not 22:35 but 0.78333... I understand that Excel does calculation in here but I need to read the original cell value without any transformation. What can be done about that? Your thoughts appreciated, Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel OLEDB reading Chinese characters problem | Excel Programming | |||
reading data from com port into excel spreadsheet | Excel Programming | |||
Reading from a .xls spreadsheet based on a cell name | Excel Programming | |||
reading cells from a spreadsheet using VB | Excel Programming |