Product and version
Filemaker Pro/Advanced 15, 16, 17
OS and version
MacOS Mojave 10.14
Macbook Pro (15-inch 2018)
When importing from .xlsx file data format is changed. For example, text 123.45 is changed to 123,45. This only happens when numbers are used and there is only one dot. Text 123.45.67 is imported correctly. Changing cell formatting does not help either.
This does not happen when importing from .xls file. Please, see attached screenshots.
How to replicate
Create .xslx file and in first cell enter 123.45. Then import data from .xlsx file into FileMaker database.
Workaround (if any)
Save .xlsx file as .xls and then do the import.