Displaying angles in degrees, minutes and seconds

[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)

 

[AlfD]

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

 

[Gord Dibben]

Fernando

Try Chip Pearson's site for this.

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

Gord Dibben Excel MVP

 

[AlfD]

Hi!

Thanks, Gord. I just knew in my bones there had to be a more elegan
way...


Al

 

[Gord Dibben]

Alf

Feedback appreciated.

Chip's pages are a marvelous resource.

For others watching.............

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

The above is the URL to Chip's topics. Scroll through and enjoy.

Gord