Text data in excel pivot table

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
Sign up Log in
2 replies · 4K views
reza_9216
Messages
8
Reaction score
0
Using Excel 2003, I'd like to display text data in the Data Items area of a
pivot table. Currently, I see the number 1 in the field. I've changed the
format to "Text", which has no effect on the data that's displayed. Is it
possible to display text data in the Data Item area of a pivot table?

Thanks
 
Mathematics news on Phys.org
Hi, that's a very fascinating math question.

Yes, the 2003 in "Excel 2003" is indeed a prime number.
 
Well, i thought the mathematic guys would know as they deals with numbers more than others...and persumably use Excel...:D