PivotSort Issue

[waqar1239]

Hi Team,
I am getting the data such as like in th pivot table
#1
#1 0
#1 00
#1 000
#1 001
#1 002
.
.
such
but i want my data such as
#1
#2
#3
.

I have no idea why data is comng like this i have date till 9000.
Kindly help me
Cheers

 

[ClaireS]

If you are including the # in your number, Excel makes this a text entry, not a number, so is sorting it "alphabetically". Therefore all numbers that start with 1 come before numbers that start with 2 and so on. Remove the # sign and just use the number. You could then use custom formatting to add the # back if you need it.