3 ms·
I can't stand excel. It thinks it knows what I mean and actually edits my data destructively, mistakenly, especially when I enter dates in day/month/year format
by mikedilger 7y ago
I can't stand excel. It thinks it knows what I mean and actually edits my data destructively, mistakenly, especially when I enter dates in day/month/year format. If you just import a CSV and then export it directly, it mangles the data. I will not tolerate such behavior.
If you have a column of phone numbers with leading zeroes, coming in from a csv, it decides it's a number and drops the leading zero, which breaks the phone number.
- davchana 7y agoI paste the data via Text Import Wizard, choose Text for the date columns, & then later split & join again as correct date format.
- bransonf 7y agoI figured out that you can technically specify type in Excel to prevent destroying the data, but by that point I’d much rather just load a data frame in R or Pandas.
- invisiblerobot 7y agoMaybe you just suck at Excel ;) https://youtu.be/0nbkaYsR94c https://youtu.be/0nbkaYsR94c