| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data from internet to excel
I am trying to setup a sheet which i copy data (sports stats)from internet
site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from internet to excel
You didn't post the url but try this
place your cursor in the field you wantright clickexport to microsoft excel -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... I am trying to setup a sheet which i copy data (sports stats)from internet site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from internet to excel
If you import the data through DataImport External DataNew web Query you
can specify that 4-3 types are not imported as dates. Gord Dibben MS Excel MVP On Thu, 2 Oct 2008 13:21:02 -0700, jj wrote: I am trying to setup a sheet which i copy data (sports stats)from internet site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from internet to excel
http://www.donbest.com/EN/main/nhl/nhl-ats-stats.html
The score column changes to date? i'm using version 2003 if that helps at all. Thanks for your help !! "Don Guillett" wrote: You didn't post the url but try this place your cursor in the field you wantright clickexport to microsoft excel -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... I am trying to setup a sheet which i copy data (sports stats)from internet site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from internet to excel
sorry to bug you again ,i didn't realize this link just went to start page.
When you click on one of the teams (eg. ANAHEIM) the team page comes up stats with heading for among other things "Score" ,this column changes to date when i copy and paste to excel 2003. Thanks again ! "Don Guillett" wrote: I could not get the external query to work but when I did a direct copy I did not get the date redirection -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... http://www.donbest.com/EN/main/nhl/nhl-ats-stats.html The score column changes to date? i'm using version 2003 if that helps at all. Thanks for your help !! "Don Guillett" wrote: You didn't post the url but try this place your cursor in the field you wantright clickexport to microsoft excel -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... I am trying to setup a sheet which i copy data (sports stats)from internet site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from internet to excel
This time I did get the same results. Try a different source
http://www.google.com/search?sourcei...9&q=nhl+scores -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... sorry to bug you again ,i didn't realize this link just went to start page. When you click on one of the teams (eg. ANAHEIM) the team page comes up stats with heading for among other things "Score" ,this column changes to date when i copy and paste to excel 2003. Thanks again ! "Don Guillett" wrote: I could not get the external query to work but when I did a direct copy I did not get the date redirection -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... http://www.donbest.com/EN/main/nhl/nhl-ats-stats.html The score column changes to date? i'm using version 2003 if that helps at all. Thanks for your help !! "Don Guillett" wrote: You didn't post the url but try this place your cursor in the field you wantright clickexport to microsoft excel -- Don Guillett Microsoft MVP Excel SalesAid Software "jj" wrote in message ... I am trying to setup a sheet which i copy data (sports stats)from internet site to excel, but when i paste some of the data (eg. score 4-3)it changes to a date as the data. Is there anyway you can setup so data will stay as orginally is on web page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting data from Excel to the internet | Excel Discussion (Misc queries) | |||
| How do I copy a mailing list from the internet to Excel? | Excel Discussion (Misc queries) | |||
| Getting Data from the Internet to Excel | Excel Discussion (Misc queries) | |||
| Copying Data From Internet to Excel | Excel Discussion (Misc queries) | |||
| Copy and paste Internet information into Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
