In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

If you're importing using a Web Query you can set it under Options to not
turn those into dates.

Web Query dialogOptionsDisable date recognition.


Gord Dibben MS Excel MVP


Hi Gord -

Thank you for the insight. I never noticed it in the recorded settings
before you mentioned it. I made the appropriate correction in the Web
query VBA. Turns out that was only the first half of the problem
however.

The worksheet that was storing all the retrieved phone numbers also saw
it as a date after I took out the ISDATE() test.

To fix that, I preset its .numberformat to "@"

Now the strings stay strings, and it feels a little cleaner.

Thanks. Is there a way to turn on and off this "clairvoyance" (probably
has an official MS name) in VBA or otherwise?

....best, Capt N.

--
Email to (yes, you can so figure it out) ;-]

Scream and shout and jump for joy! I was here before Kilroy!

Sorry to spoil your little joke. I was here but my computer broke. ---Kilroy