Currency format for a cell

Jun 24, 2008 at 12:10 PM

Hi,

How to set currency format (e.i. "zł", Polish zloty) for a cell?

Thanks

Coordinator
Jun 27, 2008 at 11:05 AM
In Excel itself, you'd use a currency format mask such as '#,##0 [$zl-415]'

I've not tried it in PHPExcel, but have a go using:
$PHPExcelObject->getActiveSheet()->getStyle($cell)->getNumberFormat()->setFormatCode('#,##0 [$zl-415]');

Let us know whether it works or not.