Uploaded January 2015 | Updated November 2026, 1 day ago
This Video shows how to use Excel to convert Decimal Degrees into Degree Minute Seconds of Longitude and Latitude. The screencast shows how to use the Text to Column tool to separate out the values and basic math function to convert each value from degrees to minutes and seconds. Finally concatenate function is used to string the texts together to the final product of DMS.
This Video shows how to use Excel to convert Decimal Degrees into Degree Minute Seconds of Longitude and Latitude. The screencast shows how to use the Text to Column tool to separate out the values and basic math function to convert each value from degrees to minutes and seconds. Finally concatenate function is used to string the texts together to the final product of DMS.










