Greetings Once Again,

I'm downloading data from a website using VBA and for some unknown reason
Excel is storing numbers as text and dates in mm/dd/yy instead of mm/dd/yyyy.
The strange thing is this doesn't happen for all the data that is downloaded.
It appears to be random.

Why is this and How can I fixed this?

I tried using the format cells, but that didn't work. I get that
notification (that green triangle) and I could update each cell as required,
but I have hundreds of cells to go through.

Thanks As Always! Kurt