| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing an angle in cells
Is there any possibility to show and calculate an angle in a cell in dms
format (##°##'##'')? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 (##°##'##'')? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format my column heading cells to display on an angle? | Excel Discussion (Misc queries) | |||
| How do I turn cells to a 45-degree angle? | Excel Discussion (Misc queries) | |||
| angle from atan | New Users to Excel | |||
| How to angle columns? Please Help! | Excel Discussion (Misc queries) | |||
| tell me if there is a way to angle the cells horizentally | New Users to Excel | |||
Linear Mode
