Skip to content
You're reading the docs for Laravel Excel 2.1. The current version is Laravel Excel 4.x (upgrade guide).

Available column formatting ​

Format namePHPExcel class reference
GeneralPHPExcel_Style_NumberFormat::FORMAT_GENERAL
@PHPExcel_Style_NumberFormat::FORMAT_TEXT
0PHPExcel_Style_NumberFormat::FORMAT_NUMBER
0.00PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00
#,##0.00PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1
#,##0.00_-PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED2
0%PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE
0.00%PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00
yyyy-mm-ddPHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2
yy-mm-ddPHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD
dd/mm/yyPHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY
d/m/yPHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH
d-m-yPHPExcel_Style_NumberFormat::FORMAT_DATE_DMYMINUS
d-mPHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS
m-yPHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS
mm-dd-yyPHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14
d-mmm-yyPHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15
d-mmmPHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16
mmm-yyPHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17
m/d/yy h:mmPHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX22
d/m/y h:mmPHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME
h:mm AM/PMPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1
h:mm:ss AM/PMPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME2
h:mmPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3
h:mm:ssPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4
mm:ssPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5
h:mm:ssPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME6
i:s.SPHPExcel_Style_NumberFormat::FORMAT_DATE_TIME7
h:mm:ss;@PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME8
yy/mm/dd;@PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH
"$"#,##0.00_-PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE
$#,##0_-PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD
[$EUR ]#,##0.00_-PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE