| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
degrees minutes and seconds
how can i make an angle in decimal show as an angle in degrees minuts and seconds? -- grandfilth ------------------------------------------------------------------------ grandfilth's Profile: http://www.excelforum.com/member.php...o&userid=28240 View this thread: http://www.excelforum.com/showthread...hreadid=486654 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
degrees minutes and seconds
On Sun, 20 Nov 2005 08:36:14 -0600, grandfilth
wrote: how can i make an angle in decimal show as an angle in degrees minuts and seconds? A1: Decimal Angle B1: =A1/24 Format/Cells/Number/Custom Type: [h]° mm' ss\" (The "degree" sign is entered by holding down the <alt key and typing 0176 on the numeric keypad). This takes advantage of the fact that there is the same relationship between degrees/minutes/seconds as there is between hours/minutes/seconds and uses Excel's built in time format. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| convert an angle to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| How do I enter degrees, minutes, seconds | Excel Discussion (Misc queries) | |||
| How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Linear Mode
