Re: MI Degrees, Minutes, Seconds to Decimal Degrees?

[Emmanuel Par�]

Why not using dmscnvrt.mbx (located in the tools directory)  But the limit of coordinates is 32 000 (integer limits)   Emmanuel Paré GIS/Programming for DBX Geomatics email:[EMAIL PROTECTED] http://www.linux-mandrake.com -----Original Message----- From: Ryan Richter <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: 15 septembre, 1999 12:42 Subject: MI Degrees, Minutes, Seconds to Decimal Degrees? I was given an excel spreadsheet that contained around 300 co-ordinates that I need to plot in MapInfo...Problem,  the co-ordinates for both latitude and longitude are all in the same cell, separated by a "-".  eg.  40-30-41, and the cell format is just general.  If anyone has a quick solution to either separate these numbers into three separate columns (then I can easily convert them into degrees, minutes, seconds), or even better, if someone has devised a program that will work in MapInfo to convert a column in this crummy format to decimal degrees I would love to hear about it ASAP.   I have downloaded many of the extra MapBasic utilities on this website and found many of them extremely useful.  If one of these will do that and I just haven't found it or figured it out please let me know.   Thanks to anyone who can solve this relatively simple, yet pain in the butt problem.   Ryan     ------------------------------------------------------------------- Ryan Richter GIS Specialist DC - Development Consultants [EMAIL PROTECTED]          (215) 348-4239  ext. 110 Fax - (215) 348-4997 ------------------------------------------------------------------- Suite 312 Penn's Court 350 South Main St. Doylestown, PA 18901 -------------------------------------------------------------------