AnsweredAssumed Answered

Import Excel spreadsheet: 39.30 becomes 39.299999999999997

Question asked by fmdataweb on Oct 27, 2016
Latest reply on Oct 27, 2016 by BowdenData

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?

Outcomes