Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |