AnsweredAssumed Answered

Decimal Place Control with Excel Recurring Pulls

Question asked by kingsley47 on Jan 12, 2011
Latest reply on Jan 12, 2011 by philmodjunk


Decimal Place Control with Excel Recurring Pulls


I am pulling data into Filemaker Pro from an excel file via a recurring data import. One field in the excel file contains names of customer specifications. The name of each specification is either an alphanumeric code or just a number. The alphanumeric combos pull in just fine, but the specifications whose names are something like 70.80995 get changed when they are imported into filemaker pro. Instead of 70.80995 appearing in the field, 70.809950000000001 will appear. How can I set it so that filemaker pulls the exact text from excel.

Limiting the number of values after the decimal place is not an option because the number of values following a decimal vary depending on the specification name.