Is it possible to insert currency with pound sign (£)?

Topics: Developer Forum, Project Management Forum, User Forum
Mar 23, 2012 at 11:31 PM

I have three fields related to invoice so i want to calculate those fields and display result with Pound sign (£) e.g. £12.45

Mar 25, 2012 at 1:52 AM

Sure, just set the following on the cells you need:

$sheet = $xl->getSheetByName("SheetName");
$sheet->getStyle("A1")->getNumberFormat()->setFormatCode('[$£-809]#,##0.00');