View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How do I validate latitude/longitude in terms of ddmmss

Do you have the latitude (pun intended) to use the format DD.DDDDDDDDD?
That is to say, express the location in terms of degrees only, with
decimal points to define accuracy instead of minutes and seconds? This
would preclude the need for data validation, altho it may entail some
conversion. It's been my preference to use decimal fractions of
degrees instead of minutes/seconds, since high degree of accuracy would
require decimal fractions of seconds.