Ron Gutiw wrote: > > When I open an Excel spreadsheet all date columns are converted to float. > Is there a trick to this?
Excel stores date and time as a float. The mantissa holds the number of days since Dec 31, 1899, and the decimal holds the hours of that day (e.g. 1.5 is noon on Jan 1, 1900.) Converting an Excel date to MapInfo is a bit tedious; I had to resort to a MapBasic routine. Peter Baum's Date Algorithms (http://www.capecod.net/~pbaum/date/date0.htm) is a good resource for date conversion algorithms, but if you don't program, then you'll have to convert your Excel dates into Year, Month, Day columns (as numbers) and rebuild them as dates in MapInfo. -- - Bill Thoen ------------------------------------------------------------ GISnet, 1401 Walnut St., Suite C, Boulder, CO 80302 tel: 303-786-9961, fax: 303-443-4856 http://www.gisnet.com/ ------------------------------------------------------------ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7827
