AnsweredAssumed Answered

Importing from .xlsx changes data formatting

Question asked by Datastudio on Nov 7, 2018
Latest reply on Nov 12, 2018 by TSGal

Product and version

Filemaker Pro/Advanced 15, 16, 17

 

OS and version

MacOS Mojave 10.14

 

Hardware

Macbook Pro (15-inch 2018)

 

Description

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.

Attachments

Outcomes