How to write the degree, minute second format in excel

		Microsoft Office Forums > Microsoft Excel > Excel
How to write the degree, minute second format in excel

01-12-2011, 07:03 PM

macropod

Windows 7 32bit How to write the degree, minute second format in excel

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Jamal,

For display purposes, you can divide the angle by 24.
For trig purposes, you can multiply the display value by 24.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 PM.