LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you convert decimal degrees to degrees minutes seconds David Excel Discussion (Misc queries) 2 September 21st 06 09:38 PM
how can i convert degrees/minutes/seconds to decimal degrees? Chrissy Excel Discussion (Misc queries) 2 April 28th 06 12:14 PM
Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal Dan Excel Discussion (Misc queries) 1 April 4th 06 11:09 AM
convert decimal degrees to degrees minutes seconds Chris r Excel Discussion (Misc queries) 2 December 6th 05 10:40 PM
Can you change Longitude and Latitude from degrees to decimal Hurley Excel Discussion (Misc queries) 1 September 30th 05 05:04 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"