View Single Post
  #1   Report Post  
Blackmore
 
Posts: n/a
Default Help With Query Web & Imported Text


Hi, i've some problem to import data from web

i have to download a table from a site, in a column there are many
value formatted in this way:
3:22:12
1:44:3
4:123:9

But when i import this data, Excel modify it and in the first two case
i have 2 cells formatted like hh.mm.ss ,
and in the third case Excel do a division and i will have a value like
this:
0,0036133694670280036133694670280036

But i don't want this..
I want to see original Data
I want to see this:
3:22:12
1:44:3
4:123:9

not this:
3.22.12
1.44.3
0,0036133694670280036133694670280036

how can i solve this problem?

I hope that my poor english will be clear :D


--
Blackmore
------------------------------------------------------------------------
Blackmore's Profile: http://www.excelforum.com/member.php...o&userid=26259
View this thread: http://www.excelforum.com/showthread...hreadid=395543