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 |
All times are GMT +1. The time now is 06:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com