Have tried importing a simple spreadsheet you have created with simple setup?
BTW, setting the field to auto-enter a calculation (replacing existing data) =
Round ( field ; 2 )
should work, if you enable auto-enters during imports. The SetPrecision() function does not do what you think it does.
Since I am actually creating the excel spreadsheet as an export from a filemaker converter setup I made to convert fixed length files into the excel, I found a fine work around by saving the files as tab delimited.
I have to admit I'm thrilled to learn the cause of the problem being the Microsoft product and that it isn't a Filemaker flaw. Yes I used 2008 and save down to xls 2004 format.
Thanks everyone! Great Forum!!!
I am actually creating the excel spreadsheet as an export from a filemaker converter setup I made to convert fixed length files into the excel
Huh? I thought you were importing FROM Excel. What exactly are you trying to do?