Does Excel have a cell format for lat/long in ° min sec format?

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?

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
<usudragon@discussions.microsoft.com> 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?