Select the cell, go to the Edit menu, choose Cells, and then the
Number tab. Select Custom in the list on the left and enter the
following format:
[h]şmm'ss\"
To get the degree sign, hold down the ALT key and enter 0186 on the
numeric keypad (to the right of the keys, NOT the numbers above the
letters).
Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)
On Fri, 3 Oct 2008 08:10:02 -0700, Mike
wrote:
How do I format a column or cell for entering Latitude & Longitude data.
Most of the data I have is degrees, minutes & seconds "nn°nn.nnn" North
Latitude by "nnn°.nn.nnn" West?