Why might some 'times' be sub-type 5 and some be sub-type 8?
Perhaps the cells that are type double are in fact recognized as dates, while
those that are strings are not recognized as such.
If you show examples of the cells that are numeric and those that are strings,
somebody will be able to tell you how to convert.
On Mon, 12 Dec 2005 20:20:01 -0800, Chet Shannon
wrote:
Anyone have a possible explaination as to why I seem to be getting an
inconsistent format on a column of times. I am downloading data from a
active server web page that gives me data in excel format. The data I get is
various columns of numbers , text and what looks like some times.
The problem is that in my time column some of the rows are variable sub-type
5 (vbDouble) and some are variable sub-type 8 (vbString). This is producing
problems for my code which is expecting all vbString type data.
In general might someone think of a reason why some times come out type 5
and some type 8? (Or a good way to convert a cell from having a vbDouble
value versus a vbString value?)
I'm stumped at this point but possibly my understanding of how this works is
lacking.
Thanks,
|