Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Decimal Degree to Degree, Minute, Second

0

How would one convert a regular angle, for example, 28.6105 (decimal degrees) into a Degrees, Minutes, Seconds format in Excel?

Answer
Discuss

Answers

1

This Microsoft site offers UDFs (User Definted Functions) to convert both DMS to decimal and the other way around. The point is that you do need a UDF. To do the same job with a formula constructed from existing, built-in Excel functions would be rather a tall order.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login