3 ms·
Not sure if this would work but have you tried quoting the values in the generated CSV ?
by tgflynn 14y ago
Not sure if this would work but have you tried quoting the values in the generated CSV ?
- kyllo 14y agoExcel ignores double quotes around the fields, it just uses them to escape commas inside the fields. The official way to do it is to insert a single quote at the beginning of every field that you don't want auto-converted. In practice this is a time-wasting pain in the neck and ruins your data for use outside of Excel.