How to Convert a Number to Degrees Minutes Seconds (DMS) Format in Excel

Learn the simple Excel formula to convert decimal numbers into degrees, minutes, and seconds format quickly and accurately.

235 views

To convert a number to degrees, minutes, seconds in Excel, use the following formula: `=TEXT(A1,"0° ") & TEXT((A1-TRUNC(A1))60,"0' ") & TEXT(((A1-TRUNC(A1))60-TRUNC((A1-TRUNC(A1))60))60,"0""""")`. Replace `A1` with your cell containing the decimal degree value. This splits the decimal number into degrees, minutes, and seconds, formatting each component for easy reading.

FAQs & Answers

  1. What is the formula to convert decimal degrees to degrees minutes seconds in Excel? You can use the formula =TEXT(A1,"0° ") & TEXT((A1-TRUNC(A1))*60,"0' ") & TEXT(((A1-TRUNC(A1))*60-TRUNC((A1-TRUNC(A1))*60))*60,"0""""") to convert a decimal degree value in cell A1 into degrees, minutes, and seconds format.
  2. Can Excel convert decimal degrees to DMS format automatically? Excel does not have a built-in automatic conversion for decimal degrees to DMS, but you can use formulas like the one above to format the numbers into degrees, minutes, and seconds.
  3. How do I display degrees, minutes, and seconds symbols in Excel formulas? You use special characters in the TEXT function, such as ° for degrees, ' for minutes, and " for seconds, ensuring they are enclosed in quotation marks within the formula.

Watch More

For more Excel tips and tricks, check out our tutorials on converting units, working with time formats, and mastering advanced Excel formulas to boost your productivity.

  1. How to Convert Time to Total Hours in Excel: Easy Formulas Explained Learn how to convert time values to total hours in Excel using simple formulas, including handling hours, minutes, and seconds.
  2. How to Calculate Minutes and Seconds in Excel Using Formulas Learn how to calculate minutes and seconds in Excel with formulas and correct time formatting for accurate time measurements.
  3. How to Extract Hours from a Time Value in Excel Using the HOUR Function Learn how to extract the hour component from time values in Excel using the simple HOUR function formula.
  4. What Is the Formula for Calculating Time in Excel? Learn how to enter and calculate time in Excel using the proper formats and formulas for accurate time management.
  5. How to Divide Time Values in Excel Easily Learn how to divide time in Excel using simple formulas and correct cell formatting for accurate calculations.
  6. How to Format Hours and Minutes in Google Sheets: A Simple Guide Learn how to easily extract and display hours and minutes in Google Sheets with formulas.
  7. How to Convert Excel Serial Number to Date Format Easily Learn how to convert serial numbers to readable dates in Excel using simple formatting and formulas.
  8. How to Create a Conversion Table in Excel: Step-by-Step Guide Learn how to easily create a conversion table in Excel with formulas to convert units like inches to centimeters in just a few steps.
  9. How to Convert Text to Dates in Excel: A Step-by-Step Guide Learn how to easily convert text to calendar dates in Excel using the DATEVALUE function.
  10. How to Convert Currency in an Excel Cell Using Formulas and Formatting Learn how to convert currency in Excel cells using formulas and formatting with exchange rates for accurate financial data.
  11. How to Convert Julian Date to Normal Date in Excel Easily Learn the simple Excel formula to convert Julian dates into standard calendar dates quickly and accurately.