Showing an angle in cells
 

Is there any possibility to show and calculate an angle in a cell in dms
format (##°##'##'')?

Showing an angle in cells
 

the problem is that you can not calculate in that format

"Latka" wrote in message
...
use a custom cell format (right click "format cells" number tab "custom")

here is the syntax

00"o"00"'"00"

the numbers you type i.e. 253945

will look like so after pressing enter 25o39'45"

Showing an angle in cells
 

=CONCATENATE(INT(A1),"°",INT(MOD(A1,1)*60),"'",INT (MOD(MOD(A1,1)*60,1)*60),"""")

Dinko Krmpotic wrote:

Is there any possibility to show and calculate an angle in a cell in dms
format (##°##'##'')?