Formatting cells as degrees?

[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?

 

[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