formating a cell

[UniStudent Coll]

can you format a cell so that it is in degrees ie 180° this is because i need
to subtract to bearings from another.

FC

 

[Gary''s Student]

Format > Cells... > Number > Custom > General"° "

 

[Gord Dibben]

See Chip Pearson's site for working with degrees, minutes, seconds and doing
arithmetic with same.

http://www.cpearson.com/excel/latlong.htm


Gord Dibben MS Excel MVP