5 ms·

Can't you set the number format on the cell?

• yen223 11y ago
  It's possible with .xls or .xlsx files, but csv files can't store number formats.
  • SQL2219 11y ago
    That is why you convert the spread sheet column to a number before you export to csv. The fulfillment center was lazy, when you paste large numbers like that into excel, it auto converts your large number into scientific notation. you simply only have to change the data type of the column and it will change it back to a number. A CSV is dumb, it only exports what Excel displays.
• protomyth 11y ago
  You set the field to text on import. Very simple. Its a shipping number so text is fine.