Displaying angles in degrees, minutes and seconds

  • Thread starter Thread starter Fernando Ronci
  • Start date Start date
F

Fernando Ronci

Hi,
In Excel 97, how do I format a cell to display an angle of, say, 37.78456
degrees as 37º 47' 4.4" ?

Thank you,
Fernando Ronci
E-mail: (e-mail address removed)
 
Hi!

Try

=INT($C$4)& CHAR(186) &" "&INT((($C$4-INT($C$4))*3600)/60)&"' "
ROUND((($C$4-INT($C$4))*3600)-INT((($C$4-INT($C$4))*3600)/60)*60,2)&""""

where your value is in C4.

It isn't fancy, but it works (at least as far as I have tested it).

Al
 
Back
Top