web query and formatting

J

JLR-Mart

I am using a web query to get data from an intranet site and put it onto a
new worksheet in Excel. I want to know if it's possible to keep the
formatting of the destination when doing this as some of the data on the web
page looks like '08E077' which gets converted to scientific notation in Excel.

Any help would be greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help removing extra TOC text from number lists used as TOC levels 0
Web Query Formatting not ready for Production 0
Capturing web page load times from VBA 3
Conditional formatting within macro? 3
Web Query - no leading zeros HELP! 0
Assign Web Query Result to a Variable 7
Macro to navigate through a Java Web-Page 1
Excel 2007 Conditional Formatting 1

Top