DMS

  • Thread starter Thread starter Yosof Ewing
  • Start date Start date
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
 
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
 
Back
Top