I would like to know how to formate a ceel to work with celestrial navigation problems. I would like to have the cell work with deg min and tenths like this 158° 32.9'. I will need to be able to add and subtract and have it return a negative number if possable.Thx
HI addboy,
Welcome to the forum.
In custom format you can have degree symbol on the right side as 0.0 "°C" but I dont think you can show the way you written.
Lets see if any other member shares some solution here.. thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Another alternative is to use a hidden column with a formula that converts your text string to a number:
With 158° 32.9' in G1, then:
Formula:
=LEFT(G1,FIND("°",G1)-1)*1+RIGHT(REPLACE(G1,LEN(G1),1,""),5)*1/60
Ben Van Johnson
Ok then when i work on two cells with is line of code, how do I get it back into the original text format?
Thx Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks