16 January 2012 17:45
CSV Comma Separated Value File Format - How To - Creativyst - Explored,Designed,Delivered.(sm)
by night.kameIf you have a table for export in which leading zeros and spaces have significance AND that file will only be viewed in Excel, then you can use an Excel specific convention in those fields where leading zeros or spaces should be preserved (in Excel). To implement this fix, double quote each field with leading zeros or spaces and place an equals sign (=) directly ahead of the first quote
W00t!