Hacker News new | ask | show | jobs
by katelynsills 4027 days ago
Nope, this is a legitimate Excel issue when opening CSVs in Excel. If you know a fix without editing the cell data type and saving back into Excel format, I'm all ears!

Edit: I'm referring to the way that most people open CSVs in Excel, by clicking on the file and having Excel be the default CSV program, not by importing it. Is there a way to turn off the scientific notation for good?
1 comments
protomyth 4027 days ago
You edit the data type because it isn't a number your importing, its a shipping tag. On import you set the column to text, its right there in the import dialog.
link
TeMPOraL 4027 days ago
ID handling 101 - just because it's made only out of digits, doesn't mean it's a number.
link
protomyth 4027 days ago
How true that is, dealing with trains, barges, and government issued ids will teach some seriously valuable lessons on that score.
link