LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 989
Default Formating Longitude and Latitude

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

"Niek Otten" wrote:

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mark" wrote in message ...
|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.
|



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Mileage from Latitude and Longitude Adams135 Excel Discussion (Misc queries) 3 September 11th 07 04:00 PM
How do I format cell as longitude/latitude (ex: 45-30-10.65)? ahmebah Excel Discussion (Misc queries) 1 March 13th 07 02:20 PM
Formating Latitude and Longitude co-ordinates Tomas Excel Discussion (Misc queries) 1 June 29th 05 12:55 AM
formula for longitude/latitude Leo Excel Discussion (Misc queries) 2 June 3rd 05 06:40 PM
Help with Latitude and Longitude. LadiFireBug New Users to Excel 1 January 22nd 05 08:54 AM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"