1factory references the "number" format of the field to determine how many places after the decimal point are imported and displayed.
To ensure that your data is displayed exactly as captured, you must set the Decimal Places in the excel sheet to the correct value. Start by selecting the data column, then:
- Select "Format"
- Select "Format Cells"
- Select "Number" under "Category"
- Set "Decimal Places" to the desired value (e.g. 4 or 5 or 6)