4 ms·
The leading zeroes problem is a constant thorn in my side. You basically have to never, ever open a CSV file in Excel.
by kyllo 14y ago
The leading zeroes problem is a constant thorn in my side. You basically have to never, ever open a CSV file in Excel.
- baak 14y agoYep. Opening a CSV file in excel: http://support.microsoft.com/kb/215591 http://support.microsoft.com/kb/215591 What a nightmare. Do they not realize how many DB tables start with 'ID'? And CSV is too common a format to just completely ignore. It's not always up to us.
- zeidrich 14y agoApplies To: - Microsoft Excel 2004 for Mac - Microsoft Excel 2001 for Mac - Microsoft Excel X for Mac Sure, it sucks that it was there at all, but the most recent mentioned is a 9 year Mac version of the software (which is written by a different team than does the Windows Office anyways).
- pfg 14y agoI believe I ran into the same problem about a year ago using Office 2010 (on Windows).
- jackalope 14y agoYes! This ridiculous bug is still out there and is why I never use 'ID' when designing my schemas. Seriously, why can't reserved words be designed to be so uncommon, you'll never have a conflict? If I see another 'klass' object in Python or email broken because someone started a sentence with 'From' I'm going to cry.
- baak 14y agoI definitely had this issue with Office 2007 during my internship a few years ago.
- wazoox 14y agoUse LibreOffice calc to import the CSV then save to Excel format. No kidding, Open/LibreOffice gives you (among others) the option to chose the type of each column at import.