I've got an excel spreadsheet that has video data in it. One of the column has the following format:
where mm is the minute, ss is the second and ff is the frame of the video. Displays just fine in Excel, but when I read it, it gets converted to a floating point value.
Unfortunately, I have a number of these to read and the location of the field is not always the same column. Is there some way to read everything in as a string instead of having it change the data on me?
Everything else reads just fine.