
HI ,
I have a problem getting large numbers displayed right in excel.
The thing is , I need to get some EANcodes (13 digits) from a database and get them into excel.
I allreay tried several options but the numbers in my xls are always shown as 4,00332E+12
Can someone explain me how I can solve this issue, i'm very new at phpexcel...
Thanks in advance
Wim



$objPHPExcel>getActiveSheet()>getStyle($cell)>getNumberFormat()>setFormatCode('0');
We use EANs too; this works for us.



it seams not work.
901616000000000000 in excel is showed like 9.02E+17. Using above method, it is 9.01616E+17.
any problem?

