Attached Images

Cliptt_4.jpg (97.5 KB, 121 views)

You can use a custom number format for the cell:
[h]° mm' ss''
The angle is input in decimal format and the 'º' is created via Alt-0186 (though you should be able to copy & paste the format from this post).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

thank u for the answer.

the problem now is how to write the angle in this formt!!! there's no relation with what we type to what is displayed!!

secondlay, when i tried to get the sin or cos of the angles, the answer is wrong!!!

is it just for display?

please, see the attched image

regards

Attached Images

Clmmip_10.jpg (111.0 KB, 99 views)

Hi Jamal,

For display purposes, you can divide the angle by 24.
For trig purposes, you can multiply the display value by 24.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

How to write 30.89 degree in degree minute and second. I did not understand the above format.

What don't you understand? Have you applied the custom format? Have you looked at the attachments?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

Please, get back to the thread below. Paul has thoroughly elaborated regarding this issue.


https://www.msofficeforums.com/excel...html#post34536



Best

Jamal

If cell “E19” is 78.359272 in degrees decimal then:
CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
Will return:
78° 21' 33.38"
It may seem complicated but it give the exact format to put in to Google Earth or similar software. U can do all your calculations in decimal. If u use radians u must convert to degrees before applying the formula.

Thanks fzuazua. Sounds to be cool. I’ll be trying it and see if it works with me

Best

Jamal

Hi fzuazua,

The code is working fine but sounds that it is for displaying purposes only. No calculations can be made!

So, for example, if the angles are required to be summed, then this operation can’t be performed

Is there still a way to have the correct display while the operations can also be preformed

Other relevant threads are

From decimal to degree
https://www.msofficeforums.com/excel...html#post50083


Angles calculations
https://www.msofficeforums.com/excel...lculation.html


Best

Jamal

Attached Images

	Clip_444.jpg (72.2 KB, 77 views)
	Clip_445.jpg (61.7 KB, 73 views)

First off Sorry for dragging up an old subject but google seemed to think it was relevant.

Thanks that sort of got me there it is a bit broken from when there was just seconds or parts of Seconds.

=CONCATENATE(TEXT(INT(E19),"00° "),TEXT(INT((E19-INT(E19))*60),"00' "),TEXT(MOD((E19*60*60),"1"),"00.000############## ##################"),"""")

Any MS Office program doesn't support degree format per se.

Macropod's solution assumes the numbers the format is applied to are dates (what is not in your case), and handles them accordingly;
All other solutions convert the value to text string -and are only working solutions for you.

You must have 2 columns - one for degree values, another for display. In case degrees are calculated only, you can hide the real degree column. Whenever you need to refer coordinates in some formula, you have to refer to degree column, not to degree display column.

@Bovski
Hi and welcome,

Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Thread closed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post