How to keep numeric data from changing to scientific notation during import from Excel file

Question

Hello,

I am importing data from an Excel file. My data becomes scientific notation and then I lose the details from the last two digits.

How can I import numbers from an Excel file so that JMP does not change the format to scientific notation?

Here is an example of the data:

Number20160609144108701201606091441087022016060914410870320160609144108704201606091441087052016060914410870620160609144108707

Thank you for your help!

Wende

Craige_Hales · Accepted Answer

What does the data represent? If it is a date-time in 2016, precise to the millisecond, the answer might be for converting it to a JMP date-time value. If it is a part number you should keep it as character data.

Is it a CSV file? Are you using text file import or Multiple File Import or Excel Import?

I'm not an Excel expert, but I think those values are string data in Excel.

Most programs (JMP included) use a double precision floating point representation that can't handle exact integers bigger than 2^53, which is smaller than those numbers.

You can make JMP use a format that will look like an integer, but least significant digits are not really there.

Format( "Fixed Dec", 18, 0 )

There are at most 15-16 significant digits in a double.

big integer values

Wende · Accepted Answer

Thank you very much for your response!

I wound up adding a letter at the beginning so that the data would import correctly.

The format is a blend of date format and sequential numbering which causes the date to not work directly.

Thanks again.

Wende

dhwkoo · Accepted Answer

If using the import tool, you can select character for the column data type.