2 Replies Latest reply on Oct 27, 2016 5:54 PM by BowdenData

    Import Excel spreadsheet: 39.30 becomes 39.299999999999997

    fmdataweb

      I'm importing a simple Excel spreadsheet and have found a strange issue I can't work out - there's a column of numbers in the spreadsheet like this:

       

      43.77

      39.30

      39.30

      39.30

      37.59

      43.77

       

      after importing this into FileMaker these same numbers appear as:

       

       

      43.77

      39.299999999999997

      39.299999999999997

      39.299999999999997

      37.590000000000003

      43.77

       

      I've copy/pasted the spreadsheet into a new value making sure I just get the values and there's no hidden numbers that are rounding as far as I can see - I'm stumped as to how 39.30 in Excel becomes 39.299999999999997 in FileMaker?