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?

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?

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?

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?

Copy data from internet to excel
 

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?

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?

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?