Thread: [Solved] How to write the degree, minute second format in excel
View Single Post
 
Old 01-12-2011, 06:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]