Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
how do I change the text case of imported data in excel? ArtLene Excel Discussion (Misc queries) 1 January 26th 05 07:08 AM
Using imported Query & Calculating Dates Woodkat Excel Worksheet Functions 1 December 8th 04 05:15 PM


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"