I've been trying to extract time from excel sheet cell to a vb text box, instead of giving me the time it gives me a double type number like "0.4375", in the excel file that cell has the value 10:30 AM.
the code I'm using to extract it is as follows:
- TextBox.Text = xlSheet.Cells(rowNum, 13).Value
This code will extract all other types of values from the excel sheet cells i have except time, I don't know why. Any help would be greatly appreciated.