Weird encoding...

Mar 4, 2010 at 9:13 PM

I've got an excel spreadsheet that has video data in it.  One of the column has the following format:

mm:ss:ff

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.

 

Thanks.