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.
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.
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.
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.
Is here someone with the same problem?.
Thanks if someone can give me a little advice.
Kjell