Web query to download web page data to excel in text format

Hi friends,

I have been trying to download stock data from google finance link (http://www.google.com/finance/getpri...&f=d,o,h,l,c,v) into excel and have created vba macro for the same.

The below is the sample data I get from the above link.

1,3882,3890.8,3862.35,3890.8,724
2,3873.6,3879.9,3873.6,3879.9,161
3,3880,3880,3873.6,3873.6,403
4,3865.3,3878.75,3865.3,3877.15,281
...
...
372,3898.65,3900,3898.55,3900,259
373,3897.2,3900,3896.05,3898.65,638
374,3890,3896,3890,3895,474
385,3901.4,3901.4,3901.4,3901.4,34

Kindly note the data highlighted in bold in the above sample. I can download all into excel as a text format (except for the bold data) since their is a comma AND decimal points both in all other data samples. However in the data highlighted in bold above, there is no decimal point only comma is appearing. When this data is transferred to excel it is converted into numeric. And this is what I do not want. I want the same data in text format with commas as I further have to do text to columns and use comma as delimiter. The data what is transferred for the highliget data point is 3.7438903896389E+21.

Experts kindly advise me on what code I should put in the web query to solve this problem.

Thanks,

R. Pandit

Hello and welcome to the forum,

You will have to tell Excel to format the cell first as text before the import. You can do this cell by cell:

Please Login or Register  to view this content.

with r being the row number

or the whole column:

Please Login or Register  to view this content.

or the whole worksheet

Please Login or Register  to view this content.

abousetta

Glad I could help. If you are satisfied with the responses then please mark the thread as solved.

Good luck.

abousetta