Convert degree from decimal number to the standard format (degre.
How to Convert degree from decimal number to the standard format (degree °
minutes ´ seconds€³. I tried custom but could not work out for some degrees. Thanks |
On Sat, 26 Mar 2005 08:23:01 -0800, "Zainelabdin"
wrote: How to Convert degree from decimal number to the standard format (degree ° minutes ´ seconds?. I tried custom but could not work out for some degrees. Thanks Here's one way: Divide your decimal degrees by 24. Then format the cell as: Format/Cells/Number/Custom Type: h° m' s.00\" Note that the degree symbol after the h is entered by holding down the <alt key and then typing 0176 on the numeric keypad; then release the <alt key. Using the above, with 5.954 in A1; B1 formatted as above; B1 containing the formula =A1/24, B1 will show: 5° 57' 14.40" --ron |
To keep degrees (Excel thinks they're hours) from rolling over to days, I
think you need to use: [h]° m' s.00\" -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Ron Rosenfeld" wrote in message ... On Sat, 26 Mar 2005 08:23:01 -0800, "Zainelabdin" wrote: How to Convert degree from decimal number to the standard format (degree ° minutes ´ seconds?. I tried custom but could not work out for some degrees. Thanks Here's one way: Divide your decimal degrees by 24. Then format the cell as: Format/Cells/Number/Custom Type: h° m' s.00\" Note that the degree symbol after the h is entered by holding down the <alt key and then typing 0176 on the numeric keypad; then release the <alt key. Using the above, with 5.954 in A1; B1 formatted as above; B1 containing the formula =A1/24, B1 will show: 5° 57' 14.40" --ron |
On Sat, 26 Mar 2005 20:39:13 -0500, "Earl Kiosterud"
wrote: To keep degrees (Excel thinks they're hours) from rolling over to days, I think you need to use: [h]° m' s.00\" Good pickup! I only tested with small numbers. --ron |
All times are GMT +1. The time now is 06:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com