Hi, This problem seems to be a challenging one around here!

I am using a Web Query in Excel 2002 to simply return data from a web
page into a worksheet. Some data on the web page are alpha-numeric
fields that cause problem when they contain the letter E. For example
the field '234E2' for which the web query returns as '2.34E+04'
(Scientific number format). If you try to convert back to Text it will
end up as '23400' which would be totally incorrect.
I have tried changing the worksheet format to Text and disabling the
Excel's Autoformat before dumping the query results but it still
returns as Scientific format. Even playing aroud with some of the
WebQuery properties such as PreserveFormatting, WebFormatting, etc.
don't work. Nothing seems to work!

Does anyone have a solution to this?

Thanks alot,
Tony