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

FAQ

Thread Tools

Display Modes

01-12-2011, 06:35 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

You can use a custom number format for the cell:
[h]° mm' ss''
The angle is input in decimal format and the 'º' is created via Alt-0186 (though you should be able to copy & paste the format from this post).

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

« Previous Thread | Next Thread »

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 07:20 PM.