Coordinates

[Todd]

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

 

[Gord Dibben]

See Chip Pearson's site.

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


Gord Dibben MS Excel MVP

 

[CLR]

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