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