View Single Post
  #1   Report Post  
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
jack jack is offline
external usenet poster
 
Posts: 97
Default Problem reading value from Excel spreadsheet

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