Hi Andrew
Use Table>Maintenance>Table Structure, then select each field in turn and
change the format to Decimal. You can then specify the number of places.
If the table has been opened in MI from an Excel file, you will have to save a
copy first and modify that, as you cannot change the Excel
Thanks for all your replies.
I ended up working around it and exporting to a .dbf which kept the 6dp for
me.
Paula
-Original Message-
From: Darrin Clement [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 17 June 2003 12:30 a.m.
To: Paula Brockhill
Subject: RE: MI-L decimal places with Excel
Have you tried opening the tab file in word and then making that column
decimal, 6?
-Original Message-
From: Paula Brockhill [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 8:52 PM
To: '[EMAIL PROTECTED]'
Cc: MapInfo List (E-mail)
Subject: RE: MI-L decimal places w
yeah i tried this...but when i change the feild types to decimals with 6dp
all of them change to -0.99
so i loose all my information.
:o(
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, 16 June 2003 3:43 p.m.
To: Paula Brockhill
Subject: Re: MI-L
Hans Vidkjer wrote:
> I need to explain to someone why they should store their lon/lat coords
> out to 6 decimal places. Is there a formula for calculating the increase
> in positional accuracy when you go from 4 to 6 decimal places?
A fairly close approximation of the size of the earth (and one