Conversion of Decimal Degree to Degrees Minutes Seconds in Excel- What is DD to DMS Formula in Excel

[@rajaalirajaali3280]

Very motivational music 🎶 with video wow very nice you achieve billion likes 💓

[@bestsolutionline]

Thank you so much 😀

[@AshokAnanth]

Or copy paste this formula I created. =CONCATENATE(ROUNDDOWN(A1,0),"°",ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0),"'",ROUND(((A1-ROUNDDOWN(A1,0))*60-ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0))*60,2),"""")

[@1950TorcidaHvar]

THANKS

[@rekayy]

Holly cow man thanks

[@BlackDancser]

What's format cell has been used?

[@daroritraders]

How to get East, West North, and south info by this formula? thx in advance.

[@asjadmehmood8066]

❤

[@bestsolutionline]

❤️❤️

[@meniporat3527]

In Excel 365, everything is easier, simpler and shorter If the value in B1 is: 72.29861 then this formula: =LET(x,INT(B1),y,(B1-x)*60,CONCAT(x,"°",INT(y),"'",ROUND(((y-INT(y))*60),0))) will yield this result: 72°17'55