Showing an angle in cells

[Dinko Krmpotic]

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

 

[Dinko Krmpotic]

the problem is that you can not calculate in that format

 

[JWolf]

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