AnsweredAssumed Answered

Importing Numeric Data in from Excel

Question asked by gladams on Apr 2, 2012
Latest reply on Apr 2, 2012 by Malcolm

I am having problems of importing numeric data with decimal points in from Excel, in that it often puts a whole string of zeros after the last digit with a number at the end. e.g. 1.874 could go to 1.8740000000000000000002 or it does the opposite and result is 1.873999999999999999999 or similar. I've tried making the field in Excel and FileMaker as text fields, but even this does not overcome it. Any suggestions on how to avoid the above would be greatly appreciated.

 

Thanks

 

Graham Adams

PlesTech Ltd.,

Outcomes