Dan Dan - 1 year ago 88
PHP Question

Correct format for strings / numbers beginning with zero?

I'm trying to use PHP to create a file containing a list of phone numbers.
It's working OK however if the phone number begins with zero, the digit is dropped from the Excel file.

Does anyone know how to set the formatting correctly so that it remains in place?

Answer Source


// Set the value explicitly as a string
$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', '0029', PHPExcel_Cell_DataType::TYPE_STRING);


// Set the value as a number formatted with leading zeroes
$objPHPExcel->getActiveSheet()->setCellValue('A3', 29);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download