importing data into excel2003 from some web site?

A

alan

could anyone help me?

why the data will be changed when import data into excel2003 from some web
site?
for example, 01234 will be changed to 1234.

Is there anyway to prevent excel removing 0?

Alan
 
D

David Biddulph

Format the cell as text before importing the data, or format as 00000 if you
want 5 digits.
 

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

Import NMEA data to excel? 0
Importing web data to Excel 2003 1
Help 4
Excel 2007 Autofilter vs Excel 2003 2
Copy data from one Excel spreadsheet to another 2
Copy data from internet to excel 6
Import Data Problem 1
Pivot table data dissappears 1

Top