Showing an angle in cells

  • Thread starter Thread starter Dinko Krmpotic
  • Start date Start date
D

Dinko Krmpotic

Is there any possibility to show and calculate an angle in a cell in dms
format (##°##'##'')?
 
=CONCATENATE(INT(A1),"°",INT(MOD(A1,1)*60),"'",INT(MOD(MOD(A1,1)*60,1)*60),"""")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Compass angles in Excel 10
Calculate Angle and Length in Triangle 25
complex numbers with excel 4
Can't view Google Maps in 3D anymore? Here's the fix. 2
Custom Angle and Alignment with VBA 1
how make an angle to show in degree, minute,second instead of degree 4
angling cell along with angled text? 4
How do I format my column heading cells to display on an angle? 1

Back
Top