Importing from excel when numbers are scientificHello 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-format/td-p/378498#:~:text=Re%3A%20How%20to%20stop%20JMP%20from%20truncating%20excel%20scientific%20notation%20format,-Apr%2020%2C%202021&text=I%20see%20the%20same%20behavior,decimals%20before%20importing%20into%20JMP.
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
Content OrganizationSharing and Communicating ResultsWindowsRe: Importing from excel when numbers are scientificwow, that's ... !
imported via Excel Import GUI (tested with Jmp 17 & Jmp 18)
workaround - via Excel AddIn:
Re: Importing from excel when numbers are scientificHave 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?
