In a Pivot Table - formatting a value to enter a pvt tbl field as

E

Eric

I am creating a simple pivot table with one field of values numbers to be
summed and a second field, occasional two letter alpha codes which are purely
descriptive. In the source spreadsheet I have formatted the column which
contains these codes as "Text". Text is supposed to remain unchanged,
however when that column of data is entered into the pivot table as a value,
it is handled as though it were numeric data, and the two letter codes don't
show up at all. Further I see no way to manipulate this data field to be
recognized as text in the pivot table itself.
How do I get the pivot table to just take this alpha data as is?
Thanks,
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maintaining text data format in a pivot table 0
Using text values in Pivot Tables 5
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Counting Text Data 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Formula to Look up values from a pivot table 1
Additional columns for Pivot table 0

Top