Web Query Changes Format to Scientific in Excel
 

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

Web Query Changes Format to Scientific in Excel
 

Follow up to this message set to excel.querydao

Tony

I have had no luck getting Excel to format stuff via a web query. Unless
you get a better answer, I think you will need a macro to go through the
results of your query and fix the problems. With a macro, you have two
options: You can run the macro every time you refresh; or you can set up a
class module that will run that macro automatically whenever the query is
refreshed. If you need help writing that macro, post the details of your
web query. It should be a pretty simple macro.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Tony" wrote in message
m...
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