I have this code to format a cell in numeric format,
$objPHPExcel->getActiveSheet() ->getStyle($colmun_alpha[$total_head+1].$row_total) ->getNumberFormat() ->setFormatCode('#,##0.00');
The problem is that it works with other cells, but with other cells, it does not work. It gives me the output ###### inside the cell. as you can see in the screenshot.
Screenshot here .
I was wondering what the problem is, since I used the same code to format other cells, as you can see. If you hover over ####, you can see this value, but not display like others.
Thanks for helping the guys.
source share