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:




but this comes into FileMaker as:




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