Once you've finished cleaning the data, and you're satisfied that you've got a good data set, delete the first three columns and save the sheet. Then save it again as a DBF. Now you can use it as a data source, and use Open Office as a front end to enter or correct data.
You were good up to that point. Deleting the first three columns will get you a bunch of error messages and/or blank cells in the remaining columns. I think what you want to do is select the result columns, copy to clipboard, and then do a "Paste Special" back in as "Value" IIRC.
Rod
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
