On Sheet1, use a vlookup formula to return the text value for each
category, e.g.:
=VLOOKUP(A2,LookupTable,2,0)
where LookupTable is the table on Sheet2.

Include the column of text values in the source range for the pivot
table, and add the text field to the pivot table's row area.

Hemant_india wrote:
hi
it's tricky to explain my problem
but i'll try
1) i am pupolating a sheet with a text file which contains(sheet1)
2) some catagories in numeric form
e g 1 for apple 2 for bannana etc
3) i have a these descriptions on another sheet(sheet2)
4) with sheet1 i create a pivottable which contains these catagories in
colunms
i want to use data on sheet2 as list to correctly display the descriptions
of those catagories.
how am i to acieve this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html