First of all hi to everyone,
I have a web query(Data>From Web>Table) that have IP numbers sometimes they come 192.0.0.1 other time 55.12.123.2 ( example what i mean to address is the inital numbers can start with 1 or 2 but 3 is the max number sequence before any dot), soo when i import the table some numbers are ok, i can see them as 192.0.0.1 but others are ok in the cell with the forma 65.4.4.4. but in the top i see 654444 and the forma is differente says number instead of the usual General that comes with the other IP address's anyone know how to fix this ?
I have a web query(Data>From Web>Table) that have IP numbers sometimes they come 192.0.0.1 other time 55.12.123.2 ( example what i mean to address is the inital numbers can start with 1 or 2 but 3 is the max number sequence before any dot), soo when i import the table some numbers are ok, i can see them as 192.0.0.1 but others are ok in the cell with the forma 65.4.4.4. but in the top i see 654444 and the forma is differente says number instead of the usual General that comes with the other IP address's anyone know how to fix this ?