How to write the degree, minute second format in excel

Jamal NUMAN · #3 01-12-2011, 06:50 PM

thank u for the answer.

the problem now is how to write the angle in this formt!!! there's no relation with what we type to what is displayed!!

secondlay, when i tried to get the sin or cos of the angles, the answer is wrong!!!

is it just for display?

please, see the attched image

regards

Quote:

Originally Posted by Jamal NUMAN

Hello everybody,

Please, see the attached image that shows my question

What I need is to write the degree, minute second format (which is used for example to measure the angles or geographic coordinates)

Normally, it’s written in the following format:

70 12’ 13’’

Thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 cell format help!!!	Raner	Excel	4	06-17-2013 11:13 PM
Excel convert format [h]:mm:ss to decimal	gchan2000	Excel	1	08-17-2010 01:36 PM
Updating excel link alters table format in PP	dbmagnus	PowerPoint	0	06-03-2010 12:12 PM
Need help in format or link in excel	handsome1968	Excel	1	05-01-2010 09:20 AM
Format Excel to look like Word	Kilconey	Excel	1	04-30-2010 09:42 AM