ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   importing data into excel2003 from some web site? (https://www.excelbanter.com/excel-discussion-misc-queries/170639-importing-data-into-excel2003-some-web-site.html)

Alan

importing data into excel2003 from some web site?
 
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

David Biddulph[_2_]

importing data into excel2003 from some web site?
 
Format the cell as text before importing the data, or format as 00000 if you
want 5 digits.
--
David Biddulph

"alan" wrote in message
...
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





All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com