Hacker News new | ask | show | jobs
by yen223 4027 days ago
It's possible with .xls or .xlsx files, but csv files can't store number formats.
1 comments

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.