Import issue while Import from Excel

[Manjit Behera]

Hi

 

Since from a long time development in Filemaker I am facing a strange issue while importing data from an excel file to my Filemaker application. In the excel (.xls/.xlsx) the data are showing correct (e.g. 1.1524) which is entered by me but when it get imported into Filemaker its showing a different value (e.g. 1.1524000000000001).

 

This issue was not showing if I do import for same data using CSV file into Filemaker.  I have tried a lot by removing all type of formatting from the excel file even I made the column to text still on import the data in Filemaker is showing wrong data. Is there anybody faced the same issue and got any solution please share with me.

 

 

Thanks,

Manjit

[LaRetta]

I am responding here as well as Tech Info since many folks aren't registered at TechNet so might not see it there.

 

This is floating decimal point issue and has been explained here:

 

http://help.filemaker.com/app/answers/detail/a_id/9281/kw/floating%20decimal%20excel

 

There have been many bug reports and posts about it back through the years.