Hi Mavis,

How is the file being created in the first place? An export from Adagio Inventory items, or a different way? If using Inventory, ensure that the data type for the field on the Export template is set to String instead of Number.

If you edit a CSV file with Excel, information that is strictly numeric may get converted to a scientific notation as you see - this is an Excel issue. Perhaps try using 'Auto-fit column widths' to display the entire 10 characters, as Excel will display numbers that don't fit in cells as scientific notation.

Try editing the CSV file in Notepad instead of Excel. This will not convert these 10-digit values.
_________________________
Regards,
Softrak Tech Support