If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Coordinates
Is it possible to display coordinates in degrees minutes and seconds in excel?
|
#2
|
|||
|
|||
Coordinates
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? |
#3
|
|||
|
|||
Coordinates
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? |
Thread Tools | |
Display Modes | |
|
|