4 ms·
Two more examples. In a CSV with zip codes, Excel drops the leading zero: Boston, 02114. A CSV with text ranges: 1-10, 11-20, 21-30... becomes 10-Jan and 20-N
by Cactus2018 6y ago
Two more examples.
In a CSV with zip codes, Excel drops the leading zero: Boston, 02114.
A CSV with text ranges: 1-10, 11-20, 21-30... becomes 10-Jan and 20-Nov!
- qayxc 6y agoThat's because CSV is an untyped data format. Why don't people use the import options available to them? You can select the precise data type of each column if you know the format anyway. While the default choices that Excel makes are questionable at times, they're both known and can easily be overridden.