1 of 1 people found this helpful
Graham may have found an ant hill,
That is a known problem with Excel.
FMI Knowledge base.
Decimal numbers are inconsistent from the original data entered when importing from Microsoft Excel in FileMaker Pro
Answer ID: 9281
Set the number fields with autoenter calc Round( self ; n ) where n is the number of digits you want to be displayed. Using your sample data, you could probably have n as large as 6 to avoid losing significant digits.
Thanks for the replies. Unfortunately the data imported varies considerably in numeric range, so rounding the number is not really a solution. I have instead captured it as text and given it a length of 12 characters, but it does not look very pretty or professional. The import is used to automatically update data on customers machines when they open the program, but there are a considerable number of fields and writing a script to tidy up the values slows down the opening of the database when there are updates.
Looks like I will have to live with it, if it is a known problem
Thanks for the replies. Unfortunately the data imported varies considerably in numeric range, so rounding the number is not really a solution.
Excel to CSV
CSV to FMP
Also, you can use number formatting options to control the display of numbers. You might want to display at three significant figures. The data remains the same and can be revealed by entering the field.