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

U

usudragon

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Text Formatting for Lat/Long applications 2
How to display minute format for a cell? 10
Custom cell format for percentage 3
If I format a currency formula in excel ... 2
NAICS Code Cell Format 3
Setting an Icon Set conditional format for a single cell??? 4
format cells to display 20 long sentences in a single cell 2

Top