Ask Experts Questions for FREE Help !
Ask
    ashokdasguptaa's Avatar
    ashokdasguptaa Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 16, 2008, 11:29 PM
    enter value of an angle
    how do we enter values of angles in degrees-minutes-seconds in excel2003 such that we can add two or more cells and perform other functions like multiplication,subtraction etc?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Dec 17, 2008, 02:40 AM

    Here's a UDF you can install to give you DMS capability in a simple function:
    How to convert degrees/minutes/seconds angles to or from decimal angles in Excel 2000

    Or, if you don't mind a geeky looking formula:
    Decimal Degrees to Degrees Minutes and Seconds - MrExcel Message Board
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Right to enter the home? [ 6 Answers ]

My mother is the sole owner of the home (the house is under her name ONLY) and, although she and my father are married on paper, neither one of them has lived in the presence of the other for over 19 years. My question is if my mother refuses to let my father into the house, does my father have a...

Trying to Enter Canada [ 1 Answers ]

I am trying to enter Canada, I had A felony 25 years ago, since then I never got in trouble, 3 years ago I tried to enter, only to be turned A way.

Do not enter! [ 51 Answers ]

I warned you!

Can he actually enter too deep? [ 4 Answers ]

My boyfriend and I have been having sex for about a month now. He has an average size penis and the sex is amazing. But afterward I always get a pressure feeling in my abdomen. Could he be thrusting too hard and going too deep into my vagina?

View more questions Search