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