ExcelBanter - display a number that is decimal degrees in Deg:min:sec format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - display a number that is decimal degrees in Deg:min:sec format (https://www.excelbanter.com/excel-discussion-misc-queries/60915-display-number-decimal-degrees-deg-min-sec-format.html)

Sterling

display a number that is decimal degrees in Deg:min:sec format

How can I create a format to display a number that is in decimal degrees, in
Degree:minute:second?

JE McGimpsey

display a number that is decimal degrees in Deg:min:sec format

See

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

In article ,
"Sterling" wrote:

How can I create a format to display a number that is in decimal degrees, in
Degree:minute:second?

All times are GMT +1. The time now is 10:11 AM.