Leading Zeros removed by Spreadsheet?

Submitted by Derick Ng on 2 September 2009 - 2:05pm

Use =”000123″ when exporting zero padded numbers in CSV to prevent the leading zeros from being removed. Works in Excel and OpenOffice
$csv->addField(‘=”‘.$student['Cda']['branch_code'].’”‘);
bookmark