| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
decimal angles
Newbie.
Is there a simply way to convert a decimal angle in dec/min/sec in Excel 2000? Thank you in advance for your assistance. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
decimal angles
One way:
If you just want to display the results: =TEXT(A1/24,"hh° mm' ss\""") If you want to calculate with the results: =A1/24 format with Format/Cells/Number/Custom hh° mm' ss\" In article , Arch wrote: Newbie. Is there a simply way to convert a decimal angle in dec/min/sec in Excel 2000? Thank you in advance for your assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i convert angles from degrees,minutes, seconds to decimal | Excel Discussion (Misc queries) | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| HOW DO I CONVERT ANGLES TO DECIMAL DEGREES | Excel Worksheet Functions | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Linear Mode
