Excel Pivot table
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? |
Excel Pivot table
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: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com