How do I get a cell to display degrees, minutes, seconds?

Guest · Dec 21, 2004

I am using Excel 2000. How do I display a function in a cell in degrees,
minutes, and seconds?

Guest · Dec 21, 2004

One way

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

Regards,

Peo Sjoblom

Guest · Dec 22, 2004

Thank you, I appreciate the guidence.

Peo Sjoblom said:
One way

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

Regards,

Peo Sjoblom

Converting Decimal Degrees to Degrees/Minutes/Seconds	1	Nov 2, 2009
how do I format a cell to display in degrees minutes seconds	1	May 9, 2006
Degrees Minutes Seconds	3	Nov 1, 2007
How do I represent values in Degrees Minutes Seconds in Excel?	2	Mar 4, 2008
Foot mark aka single quote mark?	3	Jun 19, 2008
Degrees Minutes Seconds	1	Apr 29, 2006
translate degrees to latitude longitude	3	Apr 17, 2008
Sexagesimal degrees calculations	0	Nov 12, 2008

Ask a Question