Hello,

I don't understand why FileMaker changes the value of a number when converting an Excel file to FileMaker. Please help me understand...

Thanks in advance

 

I wasn't able to reproduce the problem.

 

.

 

Edited December 2, 20205 yr by Gilbert13

I don't see how this helps move us forward.

Here's the file I used for my attempt, and the result of converting it using FMP version 18.0.3.317 under macOS 10.13.6. If you convert the same file on your system and get a different result, then there is something different about your system. If you get the same result, then there is something different about your file.

 

source.xlsx source Converted.fmp12

I convert your file in my system and get a different result than yours, I get this (77.989999999999995) I'm using FMP v19.1.3 under macOS 11.0.1.  It could be something in my system 🤷‍♂️

Anyway thank you so much for helping me.

In fact it must be something in my system since I asked a friend who has FMPA v18.3 and macos 10.13.6 to convert the excel file you useed and the result he had was the same as yours.

Thanks......