D
dharmik
I would like to know if there is a way to convert data of lats and long
into decimals in excel.
data is already entered as 27° 13' 26.00" N
and i would like to have it as 27.xxx .
Since I have a huge amount of data I was wondering if we had functio
that i could drag it for the entire column.
I tried going to cpearson website, but they require you to enter th
data in h:mm:ss form. The problem is I already have the data as 27° 13
26.00" N.
Thanks
Dharmi
into decimals in excel.
data is already entered as 27° 13' 26.00" N
and i would like to have it as 27.xxx .
Since I have a huge amount of data I was wondering if we had functio
that i could drag it for the entire column.
I tried going to cpearson website, but they require you to enter th
data in h:mm:ss form. The problem is I already have the data as 27° 13
26.00" N.
Thanks
Dharmi