software

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.00quot; 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.00quot; N.

Thanks

Dharmik--
dharmik
------------------------------------------------------------------------
dharmik's Profile: www.excelforum.com/member.php...oamp;userid=25463
View this thread: www.excelforum.com/showthread...hreadid=527646=24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(A1,quot;quot;quot;quot;,quot;quot;),quot; Nquot;,quot;quot;),quot;° quot;,quot;:quot;),quot;' quot;,quot;:quot;)Or for those Down Under
=SUBSTITUTE(SUBSTITUTE
(LEFT(A1,LEN(A1)-3),quot;° quot;,quot;:quot;),quot;' quot;,quot;:quot;)*24*
IF(OR(RIGHT(A1,1)=quot;Squot;,RIGHT(A1,1)=quot;Wquot;),-1,1)