Problem with query - import from web

Hello .


I am trying to import a table from a web-page where some of the values are
written for example as 7 -35.
Using Data/get external data/new query.

I am making a querry for importing the table into excel. Then the 7 - 35
value in transformed into the number12966.
I understand this have to do with the way excel is reading dates. But 7 - 35
in the table is not meant to be a date, but showing two different numbers (7
and 35).
I therefore have tryed to go to format, numbers and set different formats to
the cell to make it show exactly the number om the webpage (7 - 35).
The closest i was to make it work is to set the format defined to d-m (In
format/cells/self defined). Then the cell is showing 1-7. This is not
correct eigther, but in other cells this give the equal number as in the web
table. The most cells is correct but som are not.
---
Now i also have tryed to format the cell as text, but that did not work.

Is here someone with the same problem?.

Thanks if someone can give me a little advice.

Kjell

Did you try to format as text BEFORE importing?

--
Don Guillett
SalesAid Software

"Kjell Nygaard" wrote in message
...
Hello .


I am trying to import a table from a web-page where some of the values are
written for example as 7 -35.
Using Data/get external data/new query.

I am making a querry for importing the table into excel. Then the 7 - 35
value in transformed into the number12966.
I understand this have to do with the way excel is reading dates. But 7 -
35
in the table is not meant to be a date, but showing two different numbers
(7
and 35).
I therefore have tryed to go to format, numbers and set different formats
to
the cell to make it show exactly the number om the webpage (7 - 35).
The closest i was to make it work is to set the format defined to d-m (In
format/cells/self defined). Then the cell is showing 1-7. This is not
correct eigther, but in other cells this give the equal number as in the
web
table. The most cells is correct but som are not.
---
Now i also have tryed to format the cell as text, but that did not work.

Is here someone with the same problem?.

Thanks if someone can give me a little advice.

Kjell

Hello .

Yes, i did try to format as text before importing. But the result is the
same.
I am using excel 2000 frof.

"Don Guillett" wrote in message
...
Did you try to format as text BEFORE importing?

--
Don Guillett
SalesAid Software

"Kjell Nygaard" wrote in message
...
Hello .


I am trying to import a table from a web-page where some of the values
are
written for example as 7 -35.
Using Data/get external data/new query.

I am making a querry for importing the table into excel. Then the 7 - 35
value in transformed into the number12966.
I understand this have to do with the way excel is reading dates. But
7 -
35
in the table is not meant to be a date, but showing two different
numbers
(7
and 35).
I therefore have tryed to go to format, numbers and set different
formats
to
the cell to make it show exactly the number om the webpage (7 - 35).
The closest i was to make it work is to set the format defined to d-m
(In
format/cells/self defined). Then the cell is showing 1-7. This is not
correct eigther, but in other cells this give the equal number as in the
web
table. The most cells is correct but som are not.
---
Now i also have tryed to format the cell as text, but that did not work.

Is here someone with the same problem?.

Thanks if someone can give me a little advice.

Kjell