Web query issues in data format

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

Web Query Issues In Data Format

Rate this: (3/5 from 1 vote)

	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 discardedbacon on 08 Jun 2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	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 Excel Helper on 10 Jun 2009

Displaying page 1 of 1