degrees decimal minutes format for latitude longitude


G

Guest

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.
 
Ad

Advertisements

Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top