DMS

Y

Yosof Ewing

Can anybody tell me how to convert degree answers in Trig
in to degrees, minutes and seconds?

e.g. 45 degrees

=45degrees00'00" (degrees would be in symbol format).

All feedback appreciated.

Yosof
 
C

Chip Pearson

Yosof,

Divide by 24, and use a custom number format of
[hh]º mm' ss\"

To get the degree symbol, hold down the ALT key and type 0186 on
the numeric keypad at the right side of the keyboard.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

DMS to DD 3
convert to decimal degree from DMS 6
Degrees, Minutes and Seconds 2
using macro in form to convert XY coordinates 1
Decimal Degrees to DMS 5
Converting Degrees/Minutes/Seconds to Decimal Degrees 6
how can I compute from degrees to degrees-minutes-seconds? 1
How do I set up a "Unit" conversion system in EXCEL 5

Top