ExcelBanter - Can you change Longitude and Latitude from degrees to decimal

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can you change Longitude and Latitude from degrees to decimal (https://www.excelbanter.com/excel-discussion-misc-queries/47975-can-you-change-longitude-latitude-degrees-decimal.html)

Hurley

Can you change Longitude and Latitude from degrees to decimal

I need to change Long/ Lat in degree, minute, second to a decimal format.
does excel have a funtion to do this?

Duke Carey

See Chip Pearson's site for info on this

http://www.cpearson.com/excel/latlong.htm

"Hurley" wrote:

I need to change Long/ Lat in degree, minute, second to a decimal format.
does excel have a funtion to do this?

All times are GMT +1. The time now is 08:34 PM.