Is it possible to display coordinates in degrees minutes and seconds in excel?

See Chip Pearson's site.

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


Gord Dibben MS Excel MVP

On Tue, 22 Dec 2009 10:16:15 -0800, Todd
wrote:

Is it possible to display coordinates in degrees minutes and seconds in excel?

Hi Todd......

If you format a cell for Custom 000° 00' 00''

Then if you enter 0120328 it will display 012° 03' 28''

When formatting, use Alt 0176 (type numbers on the keypad only) for the
degree symbol and the single apostrophe for the minutes and two single
apostrophe's for the seconds (NOT the double apostrophe).

HTH
Vaya con Dios,
Chuck, CABGx3



"Todd" wrote:

Is it possible to display coordinates in degrees minutes and seconds in excel?