Formating Longitude and Latitude

[Mark]

I am having difficulty entering data in a cell as Longitude or Latititude. Is
there a way to format a cell for these? If not, how do I indicate the
minutes? I found the degree symbol but I don't know how to enter it without
going to 'insert symbol' each time I want to use it. I need the entries to be
recognized as coordinates as I am importing to a mapping program.

Any help would be appreciated by this computer rookie.

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am having difficulty entering data in a cell as Longitude or Latititude. Is
| there a way to format a cell for these? If not, how do I indicate the
| minutes? I found the degree symbol but I don't know how to enter it without
| going to 'insert symbol' each time I want to use it. I need the entries to be
| recognized as coordinates as I am importing to a mapping program.
|
| Any help would be appreciated by this computer rookie.
|

 

[Mark]

Thank you so much! It is the information I was looking for. This is my first
time using the discussion group. I am extreamly impressed.
Thanks again,
Mark