How to stop JMP from truncating excel scientific notation format

[#1]

Hello,

I'm trying to import an .xlsx into JMP using Excel Import Wizard. It seems that JMP keeps truncating the excel scientific notation data to 3 significant digits. 

First image shows the view over in Excel - the data is in scientific notation with 2 decimal points shown but with 8 significant digits. 

Second image is the Excel import wizard view. 

Third image is the resultant data table view in JMP - data is truncated to 3 significant digits. 

Please share tips on how to stop JMP from doing this. I would like to maintain similar significant digits as the excel spreadsheet. 

Thanks.

 

 

 

[#2]

 

Just a quick question, if you right click on the column where the data looks truncated and get Column Info. what is the width set to? If you change that value, you will change the # of sig digits. Not sure if this will solve your problem.  There are also some options selecting the Best option drop down.

[#3]

That doesn't do anything, since the importing wizard have already truncated it to 3 significant digits.

See image attached.

[#4]

I see the same behavior and the only workaround I've found is to change the format in Excel to show more decimals before importing into JMP. 

It can be done with a VBA script, which in turn can be run from JSL. See e.g. Re: JSL: Open a VBS script 

[#5 · Accepted solution]

Thanks, this is a good workaround.
Would be nice if SAS fixed/improve the wizard so that it does not truncate the data. It have caused unwanted deltas in my report.