New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

format cells to show Degrees/minutes/seconds

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

format cells to show Degrees/minutes/seconds

Postby DrBatUOP » Thu Dec 22, 2011 4:51 pm

How can I format cells to show How can I format cells to show Degrees/minutes/seconds? (Arc and angle measurements as in Trigonometry or Geometry or Astronomy)? (Arc and angle measurements as in Trigonometry or Geometry or Astronomy)

The cells should also enable arithmetical calculations.

Thank you.
  • 0

DrBatUOP
Rookie
 
Posts: 1
Joined: Dec 22, 2011
Reputation: 0

Re: format cells to show Degrees/minutes/seconds

Postby Sisyphus » Thu Dec 22, 2011 6:47 pm

Hi,
You may find what you need at this link:
http://www.cpearson.com/excel/LatLong.aspx

I hope this helps.
Merry Christmas! :D
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Re: format cells to show Degrees/minutes/seconds

Postby Shafiullah » Mon Jan 02, 2012 12:58 pm

hope this will help u.
  • 0

You do not have the required permissions to view the files attached to this post.
Shafiullah
Regular
 
Posts: 55
Joined: Dec 6, 2011
Reputation: 0


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 246 guests