Text data in excel pivot table

[reza_9216]

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

 

[Goongyae]

Hi, that's a very fascinating math question.

Yes, the 2003 in "Excel 2003" is indeed a prime number.

 

[reza_9216]

Well, i thought the mathematic guys would know as they deals with numbers more than others...and persumably use Excel...:D