Home > Forum Home > Automating Data Analysis Tasks > Web query issues in data format Share

Web query issues in data format

Excel Help for Web Query Issues In Data Format in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Web Query Issues In Data Format

Rate this:
(3/5 from 1 vote)
Sad
Hi,

I'm trying to download data from the following Taiwan Exchange site using web query. However, when I download the list, the "0" at the beginning of every number is automatically erased. Is there a way web query to import the entire list as text format?

[http://mops.twse.com.tw/server-java/t05st49_4?off=1&colorchg=1]

Thanks,
[http://www.mrexcel.com/forum/report.php?p=1961028]   

 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Format the column as text
Rate this:
(3/5 from 1 vote)
You need to format the column where the numbers are downloaded to as text before running the web query.  This way it will keep the 0 at the beginning.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Web query issues in data format in the

© Business Spreadsheets   Legal   Follow us: