ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Converting numbers to longitude and latitude (https://www.excelbanter.com/excel-worksheet-functions/104557-converting-numbers-longitude-latitude.html)

avb1958

Converting numbers to longitude and latitude
 
I have a spreadsheet that is supposed to contain longitude and latitude but
the fields are in number format so a mapping program does not recognize the
data. Does anyone know an easy way to format the numbers in lat/long?

Bob Phillips

Converting numbers to longitude and latitude
 
Maybe this will help http://www.cpearson.com/excel/latlong.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"avb1958" wrote in message
...
I have a spreadsheet that is supposed to contain longitude and latitude

but
the fields are in number format so a mapping program does not recognize

the
data. Does anyone know an easy way to format the numbers in lat/long?




tim m

Converting numbers to longitude and latitude
 
http://www.cpearson.com/excel/latlong.htm

This link might be of some help to you.

"avb1958" wrote:

I have a spreadsheet that is supposed to contain longitude and latitude but
the fields are in number format so a mapping program does not recognize the
data. Does anyone know an easy way to format the numbers in lat/long?



All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com