Hi All,
I am struggling with something related to coordinates;
I have been given some coordinates for a cable: they are in excel but I had to modify a bit it as it was with blanks rows and things like that.
the original format of each cell is :
latitude: N32 28.5701
longitude : E034 53.1880
so in order to import all the coordinates into GIS (ARCGIS 10.2.2 desktop), I modified a bit the cells to remove the letters "N", "E" and the spaces between the numbers.
It does not recognize the zero as first number so I managed to leave it but when I import it in GIS the "0" disappears anyway.