| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Web Site Data | New Users to Excel | |||
| Importing Web Data into Excel from a Password Site | Setting up and Configuration of Excel | |||
| Importing data into Excel 2003 from a Web site | New Users to Excel | |||
| Importing data into Excel 2003 from a Web site | Excel Discussion (Misc queries) | |||
| External Data to be used as in a pull down menu in Excel2003 | Excel Discussion (Misc queries) | |||
Linear Mode
