Formatting cells as degrees?

  • Thread starter Thread starter Nigel Molesworth
  • Start date 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?
 
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
 
Back
Top