topic Re: Importing from excel when numbers are scientific in Discussions

Importing from excel when numbers are scientific

Katz0801 — Fri, 31 May 2024 13:02:17 GMT

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-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

Re: Importing from excel when numbers are scientific

Mark_Bailey — Fri, 31 May 2024 15:56:04 GMT

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?

Re: Importing from excel when numbers are scientific

hogi — Sat, 01 Jun 2024 16:14:58 GMT

wow, that's ... !

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

workaround - via Excel AddIn:

(view in My Videos)