Column formating

Topics: Developer Forum
Jul 29, 2010 at 3:48 PM

Hey everyone, i'm having some trouble formating columns.


I would like to have a column in percentage ( like 23,45%  ) and an other one in euros ( like 1234,12€ )... But i must admit i don't know how.


I thank you in advance for your help.

Jul 30, 2010 at 1:39 PM
$objPHPExcel->getActiveSheet()->getStyle('B1:B13')->getNumberFormat()->setFormatCode('0.00_[$EUR ]');