Formatting cells as degrees?

  • Thread starter Nigel Molesworth
  • Start date
N

Nigel Molesworth

I want to add two columns to a spreadsheet with the latitude and
longitude of the location, either in the format:

DEGREES MINUTES SECONDS or DEGREES MINUTES.DECIMINAL-MINUTES

How can I format the cells like this?
 
N

Niek Otten

Hi Nigel,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to add two columns to a spreadsheet with the latitude and
| longitude of the location, either in the format:
|
| DEGREES MINUTES SECONDS or DEGREES MINUTES.DECIMINAL-MINUTES
|
| How can I format the cells like this?
|
| --
| Nigel M
 

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

Top