AnsweredAssumed Answered

Import from Excel .xlsx Numbers Stored as Text Issue

Question asked by fmdataweb on Sep 19, 2018
Latest reply on Sep 20, 2018 by Andy Hibbs

I have an Excel .xlsx file with multiple worksheets that I receive from a supplier. The columns are stored as text, but the data is not coming into Excel 'as is' into FileMaker text fields.

 

For example one cell in Excel has:

 

10E8

 

but this comes into FileMaker as:

 

1.0e+9

 

I've double checked everything to make sure it is stored as text in both Excel and FileMaker but it keeps coming through like this. Other examples include:

 

10E9 becomes 1.0e+10

10E10 becomes 1.0e+11

Outcomes