hi all!

in my worksheet a particular field (COL) contains "two digit numbers,some alphabets & some alphanumerals"..like (10,20,30,AA,BB,A1,B3,...).

the problem is after creating a pivot table while i am trying to group that particular filed i am getting the msg "can't group that field".

how to overcome the problem?

help pl!

-via135