Units to be set through getFormat()

[Princess]

this.styleKg.setDataFormat(wb.createDataFormat().getFormat("#,##000 'kg'"));


is not setting the format in the cell with POI 2.5 .basically i want 1000 Kg
to be written in the cell
along with the unit.

The same user defined format works in Excel..

But to display %
this.stylePer.setDataFormat(wb.createDataFormat().getFormat("0.00%")); is
working

thanks