# Available column formatting

Format name PHPExcel class reference
General PHPExcel_Style_NumberFormat::FORMAT_GENERAL
@ PHPExcel_Style_NumberFormat::FORMAT_TEXT
0 PHPExcel_Style_NumberFormat::FORMAT_NUMBER
0.00 PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00
#,##0.00 PHPExcel_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-dd PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2
yy-mm-dd PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD
dd/mm/yy PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY
d/m/y PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH
d-m-y PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYMINUS
d-m PHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS
m-y PHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS
mm-dd-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14
d-mmm-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15
d-mmm PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16
mmm-yy PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17
m/d/yy h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX22
d/m/y h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME
h:mm AM/PM PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1
h:mm:ss AM/PM PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME2
h:mm PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3
h:mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4
mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5
h:mm:ss PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME6
i:s.S PHPExcel_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