Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
While reading Excel file, time value eg 00:30 display me 2.0833333E-02
- Thread starter Som76
- Start date
CDate(0.0625) will show 1:30 (subject to your locale settings)
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
- Thread starter
- #4
Thank you for the suggestions.
Dyarwood, I cannot have the option to format the sheet, since the xlsheets are output of a separate application from another organisation. I am developing a application to transfer these excel sheets to our company Dataware house. The transfer work will be done by normal data entry operator and more likely the operator will not have rights to edit the sheets. So thats the problem that I cannot ask to format each sheet. And the other problem is there will be huge amount of sheets from different organisations. Format each sheet will be very hectic.
John, what u said is ok, but if i use this i cannot distinguish if 0.0625 is for Time or its a normal read. My excel sheet has normal readings as well in decimals. its difficult to differentiate which readings i will say CDate and which one i have to take as it is.
thats my problem
Thanks for your all efforts. I also trying to find a way out.
Somu
Dyarwood, I cannot have the option to format the sheet, since the xlsheets are output of a separate application from another organisation. I am developing a application to transfer these excel sheets to our company Dataware house. The transfer work will be done by normal data entry operator and more likely the operator will not have rights to edit the sheets. So thats the problem that I cannot ask to format each sheet. And the other problem is there will be huge amount of sheets from different organisations. Format each sheet will be very hectic.
John, what u said is ok, but if i use this i cannot distinguish if 0.0625 is for Time or its a normal read. My excel sheet has normal readings as well in decimals. its difficult to differentiate which readings i will say CDate and which one i have to take as it is.
thats my problemThanks for your all efforts. I also trying to find a way out.
Somu
- Status
