convert an angle to degrees minutes seconds

G

Guest

angles are formatted like 90.5 degrees. or 90 degrees 30 mins 00 seconds it
shoult look like this 90* 30' 00" (the * is a degree symbol) i odnt know how
to get excell to do this
 

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

How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal 2
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show 4
Want to display degrees, minutes, seconds. (0°00'00") 1
Imputting an angle degree. Degree, minute, second 6
Converting the sine of an angle to degrees, minutes, and seconds 6
Degree, Minutes, Seconds 2
How do you convert decimal degrees to degrees minutes seconds 2
Degrees, Minutes and Seconds 2

Top