webquery loses format of leading zero and to scientific

  • Thread starter Glen: Webquery format
  • Start date
G

Glen: Webquery format

Hi, there:

I pull data from a web page using excel web query. The data have date,
number and text. The problems are

1. The codes such as 01, 02 lose the leading zeros in excel
2. The large numbers such as 358762088221 was converted into scientific as
3.58E+12. I need the original format becasues it is account number.

I tried every setting in webquery and can't figure out. Help is appreciated.

Thanks

Glen
 
B

bill gras

Hi Glen

When you find out let me know I have a similar problem
no body seems to know
I will check your thread
Thanks
bill gras
 

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

Time format hh:nn drops leading zero 0
Handling hhmmss time format 6
Adding a leading zero "0" to a number in a cell 2
Web Query Formatting not ready for Production 0
Converting a number (17 characters) to text (Scientific Notation) 4
Web Query - no leading zeros HELP! 0
Web Query Changes Format to Scientific in Excel 1
Leading zeros in Excel 2

Top