convert an angle to degrees minutes seconds

's Computer Specifications

angles are formatted like 90.5 degrees. or 90 degrees 30 mins 00 seconds it
shoult look like this 90* 30' 00" (the * is a degree symbol) i odnt know how
to get excell to do this

's Computer Specifications

See

http://cpearson.com/excel/latlong.htm

In article <3350A92A-E3AF-4977-B034-(E-Mail Removed)>,
Mac <(E-Mail Removed)> wrote:

> angles are formatted like 90.5 degrees. or 90 degrees 30 mins 00 seconds it
> shoult look like this 90* 30' 00" (the * is a degree symbol) i odnt know how
> to get excell to do this

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting the sine of an angle to degrees, minutes, and seconds	JungleJim74	Microsoft Dot NET	6	13th Jul 2009 10:27 PM
How do you convert decimal degrees to degrees minutes seconds	=?Utf-8?B?RGF2aWQ=?=	Microsoft Excel Misc	2	21st Sep 2006 09:38 PM
convert decimal degrees to degrees minutes seconds	=?Utf-8?B?Q2hyaXMgcg==?=	Microsoft Excel Misc	2	6th Dec 2005 10:40 PM
How can I convert degrees minutes seconds to decimal degrees	=?Utf-8?B?SGVpZGk=?=	Microsoft Excel Worksheet Functions	1	23rd Sep 2004 02:55 PM
enter an angle in degrees minutes seconds (dms) into spreadsheet	=?Utf-8?B?aGFydHI=?=	Microsoft Excel Worksheet Functions	1	12th Aug 2004 03:24 PM