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,
--
Chet