K
Kjell Nygaard
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
.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