Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
degrees decimal minutes format for latitude longitude
Does anyone know if there is a way to easily display latitude and longitude
as degrees decimal minutes so that it is still a number? The starting point could be decimal degrees or directly enter degrees decimal minutes. It is relatively easy to display degrees minutes seconds using a time format, but I can't see how to make a cell format that will display degrees and decimal minutes. It seems that with all the interest in using GPS devices and looking at the globe via satellite imagery that Microsoft would be very interested in making cell formats just for the variants of latitude and longitude as they have done for time and dates. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
degrees decimal minutes format for latitude longitude
Hi,
Microsoft hasn't but Chip Pearson has! http://www.cpearson.com/excel/latlong.htm HTH Martin "latitudes" wrote in message ... Does anyone know if there is a way to easily display latitude and longitude as degrees decimal minutes so that it is still a number? The starting point could be decimal degrees or directly enter degrees decimal minutes. It is relatively easy to display degrees minutes seconds using a time format, but I can't see how to make a cell format that will display degrees and decimal minutes. It seems that with all the interest in using GPS devices and looking at the globe via satellite imagery that Microsoft would be very interested in making cell formats just for the variants of latitude and longitude as they have done for time and dates. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
degrees decimal minutes format for latitude longitude
Thankyou for the response. Unfortunately I had already been there and Chip
does not answer the question I am asking. He does deg min sec, not deg decimal-minutes. The difference is something like 45 deg 45 minutes 45 sec versus 45 deg 45.75 min. The method Chip uses essentially takes the hours min sec time format of Excel and uses it for deg min sec. So I am still looking for an answer that does not involve a huge string of INT and MOD and *60..................... !!! Thanks. "MartinW" wrote: Hi, Microsoft hasn't but Chip Pearson has! http://www.cpearson.com/excel/latlong.htm HTH Martin "latitudes" wrote in message ... Does anyone know if there is a way to easily display latitude and longitude as degrees decimal minutes so that it is still a number? The starting point could be decimal degrees or directly enter degrees decimal minutes. It is relatively easy to display degrees minutes seconds using a time format, but I can't see how to make a cell format that will display degrees and decimal minutes. It seems that with all the interest in using GPS devices and looking at the globe via satellite imagery that Microsoft would be very interested in making cell formats just for the variants of latitude and longitude as they have done for time and dates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
Can you change Longitude and Latitude from degrees to decimal | Excel Discussion (Misc queries) |