Import from Excel decimal problem

Discussion created by dariusb on Sep 27, 2016
Latest reply on Sep 27, 2016 by dariusb


My first post so I hope I can be clear!


I have a FMP13 database that needs to regularly import from Excel to update matching records in a found set. The matching field frequently contains numbers like 4547.0231 but as the attached screenshot shows, in the import dialog it sees some of these numbers with very small decimal errors which means the fields don't match.  I've done a bit of reading about Excel and am wondering if this arises with decimal fractions which can only be represented in binary with recurring digits or sequences - but if true, it still doesn't help!  This is running on a Mac but I've tried it on Windows as well with the same result.

Does anyone know what's going on or am I going to have to redesign something?  I should mention that the field 14145.0503 you can see is not a calculated result in the spreadsheet, it's a direct input.

Many thanks