| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you convert decimal degrees to degrees minutes seconds
Is it possible to convert decimal degrees to degrees minutes seconds in Excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert decimal degrees to degrees minutes seconds
hi David
The whole units of degrees will remain the same (i.e. in 121.135° longitude, start with 121°). Multiply the decimal by 60 (i.e. .135 * 60 = 8.1). The whole number becomes the minutes (8'). Take the remaining decimal and multiply by 60. (i.e. .1 * 60 = 6). The resulting number becomes the seconds (6"). Seconds can remain as a decimal. Take your three sets of numbers and put them together, using the symbols for degrees (°), minutes (€˜), and seconds (") (i.e. 121°8'6" longitude) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "David" escreveu: Is it possible to convert decimal degrees to degrees minutes seconds in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert decimal degrees to degrees minutes seconds
Hi David, Micorsoft published it at:
http://support.microsoft.com/?kbid=213449 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "David" escreveu: Is it possible to convert decimal degrees to degrees minutes seconds in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| convert an angle to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Linear Mode
