I'm working with php with the PHPExcel library and I have a table where some information is saved and between it a column of the table are numeric data, there is a button to export the table to an excel document and export everything well except for the numerical data, where when the number is composed of more than 11 digits, then place at the end of the number in question a zero, replacing the number that should be the last.
That is, if this is the number in my system: 7802200266193, as it is greater than 11 digits, in the excel you can see it is: 7802200266190, note that it eliminates the 3 that was the last one and replaces it with 0 and I need that it looks as it is in the system, that is to say 7802200266193. To bring me those numerical data I am using the following:
$objPHPExcel->getActiveSheet()->getStyle('A'.$contador)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER);
But it is not working as I would like for what I have already specified. I appreciated the help you can give me.