try

' .WebFormatting = xlWebFormattingNone

--
Don Guillett
SalesAid Software

"RonMosley" wrote in message
...
I have a web query based excell spreadsheet. One column contains page
numbers that link to the information I need. Pages such as 7-1 are imported
as July 1 instead of text. A macro can take care of the display with
"mm-dd", but I can not apply this to the entire column because then page 10
will display as Jan 10. If I format the entire column as text, then Jun 1
will display as 38139. There are over a hundred pages to selectively format.
I had a macro that did just that, then the web page changed and the
formating no is off.

Any way to force the import to be text only?