Excel String data not read correctly by LabView

[GovBob]

 I have some data in Excel spreadsheets. I basically created a timestamp using get date time in seconds, ran it through format date/time string using %H:%M:%S as the format string and then wrote that value into a Excel spreadsheet using the Report Generation Toolkits' Excel Easy Table.vi. The data comes out well on the spreadsheet (i.e. 17:29:23).

 Now I need to retrieve that string data in that same format but when I read it from the spreadsheet using the Excel Get Data.vi it comes out as something like 0.7246729 (not exactly the same number but close).

 Any ideas on why the data is not read correctly or what I need to do to format it?

 Note: I've also tried another set of .llbs that someone wrote(NI website) for retrieving data from a spreadsheet and came up with the same incorrect data.

Message Edited by GovBob on 09-05-2008 04:08 PM

[GovBob]

My BAD. Turns out Excel formatted the string as I put it into the spreadsheet. I'll have to read the documents located on this site on how to deal with it.