software

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 doesn’t work?

The data area won't display text fields as text. You can add the field
to the row area, where the text will be displayed. Then add another
field to the data area, to show the count of the text fields.

Sue wrote:
gt; How do I add Text fields to the data area in a pivot table. When I try to
gt; add a text column to the data area it automatically converts it to a number
gt; and displays a number. I have tried formatting to text and it doesn’t work?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html