How do I add Text fields to the data area in a pivot table. When I try to
add a text column to the data area it automatically converts it to a number
and displays a number. I have tried formatting to text and it doesnt work?