3 Replies Latest reply on Mar 19, 2013 12:20 PM by disabled_ntaylor

    Import .55 results in .55000000000000004

    CarolQ

      Summary

      Import .55 results in .55000000000000004

      Product

      FileMaker Pro

      Version

      12.0v3

      Operating system version

      Windows XP SP 3

      Description of the issue

      importing .55 from a .xlsx file comes in as .55000000000000004

      Steps to reproduce the problem

      Create an Excel .xlsx file with Column A and Column B
      Put a name in column A, put .55 in column B

      When you open the xlsx file from FileMaker, or import it, the .55 becomes .55000000000000004.

      You have to CLICK into the field to see the expanded number, otherwise you don't know it has happened.

      Expected result

      .55 should import as .55, not .55000000000000004

      Actual result

      .55000000000000004

      Workaround

      After import, use the Replace script step to round the field to the number of decimal places you really want.

      Filemaker_Import_55_bug_screenshot.jpg