formatting numbers in pivot table after grouping them

[lezawang]

Hi
I have a table which has a column called Salary. in that column, I have number from 10000 to 100000. I create a pivot table from that table. In pivot table, I put Salary field as my Row and then I grouped these number and I got something like the one below. I want to format these number to show something like the following

14K - 25K
26k - 40K

So before grouping, I right click and formatted these number to #,K
but when I group them, I would loos that format. How can I format these numbers after grouping them? Thank you so much.


[TABLE="width: 92"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[/TR]
[TR]
[TD]14980-24979[/TD]
[/TR]
[TR]
[TD]24980-34979[/TD]
[/TR]
[TR]
[TD]34980-44979[/TD]
[/TR]
[TR]
[TD]44980-54979[/TD]
[/TR]
[TR]
[TD]54980-64979[/TD]
[/TR]
[TR]
[TD]64980-74979[/TD]
[/TR]
[TR]
[TD]74980-84979[/TD]
[/TR]
[TR]
[TD]84980-94979[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]