5 ms·

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 a

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?

protomyth 11y 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.
- TeMPOraL 11y ago
  ID handling 101 - just because it's made only out of digits, doesn't mean it's a number.
  - protomyth 11y ago
    How true that is, dealing with trains, barges, and government issued ids will teach some seriously valuable lessons on that score.