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 <Todd@discussions.microsoft.com>
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?