# Column formatting To tell Excel how it should interpret certain columns, you can use `->setColumnFormat($array)`. // Format column as percentage $sheet->setColumnFormat(array( 'C' => '0%' )); // Format a range with e.g. leading zeros $sheet->setColumnFormat(array( 'A2:K2' => '0000' )); // Set multiple column formats $sheet->setColumnFormat(array( 'B' => '0', 'D' => '0.00', 'F' => '@', 'F' => 'yyyy-mm-dd', )); > Go to the reference guide to see a list of available formats.