Importing from excel when numbers are scientific

[#1]

Hello all,

I have the same problem as this post from 2021:

https://community.jmp.com/t5/Discussions/How-to-stop-JMP-from-truncating-excel-scientific-notation-f....

I have data in an excel in the scientific format that when opened and imported into JMP is being truncated rather than the full value being taken. I understand that I can change the format in excel and that is the solution that was given in the linked post. Just wondering if this is something that can be solved in another way without editing the excel? The excel sheet is used by lots of people for data analysis so is often put back into scientific format that's why if it's something that can be done during the opening using JMP that would be better than each time having to check and edit the excels. 

Thanks 

[#2]

Have you tried interactively importing with the wizard? If it allows you to change settings and succeed, it will also write the script as a table property that you can use independently.

Can you share an example of one of these workbooks? Even a partial sample without identifiers?

[#3]

wow, that's ... !

imported via Excel Import GUI (tested with Jmp 17 & Jmp 18)

workaround - via Excel AddIn: