On Fri, 7 Dec 2007, richard head wrote:
I'm extracting dates and strings, some strings contain time code values
i.e. "00:27:01".
These values are designated as CELL_TYPE_NUMERIC
Excel is wonderful like that. Almost everything is either a string or a
floating point number, and formatting is used to emulate all the different
possible data types off of those two.
Either prefix your times with a ' when you enter them (so that excel will
treat them as a literal string, and not do anything "helpful" with them),
or just grab the floating point cell value and format it. It's almost
certainly going to seconds or miliseconds since midnight
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
