When importing an Excel table with scientific or percentage formatting, Jmp drops decimals that are not displayed in the format. When formatted as a number - or even a fraction, all decimals are imported correctly.
Also, importing dates does not work when the date format is in dd-mm-yyyy format and Jmp finds a date in the first row that could fit into the mm-dd-yyyy format. Jmp simply delete all dates that do not fit the mm-dd-yyyy format.
Here is an example:
Excel file:
![2017-10-27 13_54_40-decimal_test.xlsx - Excel.png 2017-10-27 13_54_40-decimal_test.xlsx - Excel.png](https://community.jmp.com/t5/image/serverpage/image-id/8170i0A27760BB658A686/image-size/large?v=v2&px=999)
File imported in Jmp:
![2017-10-27 13_54_48-Sheet1 - JMP Pro [4].png 2017-10-27 13_54_48-Sheet1 - JMP Pro [4].png](https://community.jmp.com/t5/image/serverpage/image-id/8154iAC2CE6FCA30B8427/image-size/large?v=v2&px=999)
Decimals for percentage and scientific formats are lost during import (changing format does not help...)
Forcing a text import is a workaround for the date issue when the data file contains column names that can only be interpreted as text, but this workaround does not work for the number issue. Please fix both issues!