enter an angle in degrees minutes seconds (dms) into spreadsheet

[hartr]

Is there a way to enter angle info into a excel spreadsheet formula?

 

[Gord Dibben]

See Chip Pearson's page on this subject.

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

Gord Dibben Excel MVP