Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Lats and longs to decimals
I would like to know if there is a way to convert data of lats and longs 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 function that i could drag it for the entire column. I tried going to cpearson website, but they require you to enter the data in h:mm:ss form. The problem is I already have the data as 27° 13' 26.00" N. Thanks Dharmik -- dharmik ------------------------------------------------------------------------ dharmik's Profile: http://www.excelforum.com/member.php...o&userid=25463 View this thread: http://www.excelforum.com/showthread...hreadid=527646 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Lats and longs to decimals
=24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(A1,"""","")," N",""),"° ",":"),"' ",":") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Lats and longs to decimals
Or for those Down Under
=SUBSTITUTE(SUBSTITUTE (LEFT(A1,LEN(A1)-3),"° ",":"),"' ",":")*24* IF(OR(RIGHT(A1,1)="S",RIGHT(A1,1)="W"),-1,1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert lats and longs to decimals | Excel Worksheet Functions |