That old doubt with Excel cell formatting is causing me problems now. I use laravel framework and to export the data I use Laravel Excel .
I am formatting the cell for text type and even then Excel continues rounding the values and changing the ending to 0000. Follow my example.
Passing the cell to text type.
$sheet->setColumnFormat(array(
'B' => '@'));
Result in the worksheet.
7,256E+18 => 7256001273850860000 // valor que sai na célula no excel
7256001273850860168 // valor que era para ser gerado
If anyone can help, I am very grateful. Thanks ..