Thread: Does Excel have a cell format for lat/long in ° min sec format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Does Excel have a cell format for lat/long in ° min sec format?
Check out Chip Pearson's site for help on this.

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


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 08:55:02 -0700, usudragon
wrote:

I want to correctly display the latitudes and longitudes of a list of
locations in the typical degree, minute, second format rather than a decimal.
Does anyone know whether or not this is possible?

Reply With QuoteReply With Quote