Decimal and Thousands seperator

Topics: Developer Forum, User Forum
Apr 2, 2008 at 2:30 PM

how can i format a Number,say 20000, to 20.000 ?
When i use PHPExcelStyleNumberFormat::FORMATNUMBER00 i get 20000,00 and 20000 with PHPExcelStyleNumberFormat::FORMAT_NUMBER.
Thats ok but how can i set the thousands seperator without converting the Cell to a String ?
Apr 3, 2008 at 6:10 AM
Can you try specifying the format yourself? (ie '#.##0,00')
Apr 3, 2008 at 6:52 AM

setFormatCode("#,##0.00"); works perfectly.
Didn't know that it's possible to define you own format.
(Although i should have recognized it after taking a look at the definition of the FORMAT_ Constants...)

thx for help