Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tomas
 
Posts: n/a
Default Formating Latitude and Longitude co-ordinates

How can I format numbers for Longitude and Latitude co-ordinates?
  #2   Report Post  
Damon Longworth
 
Posts: n/a
Default

Format the numbers as time with a dot instead of colon. Something similar
to:

[h].mm.ss

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Tomas" wrote in message
...
How can I format numbers for Longitude and Latitude co-ordinates?



Reply
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
Can distance be calculated using latitude and longitude? Paxton Excel Worksheet Functions 1 May 2nd 05 02:34 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 03:33 AM.

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"