Right-click on one of the values in the pivot table that you want to be text
instead of a number. From the drop-down, select 'Format Cells'. Select
'Text' or 'Date' or whatever format you need.
HTH,
Gary Brown
"Neil" wrote:
For the life of me i can't figure out how to make my pivot table display text
values instead of numbers. I have a spreadsheet with events and dates and
i'm trying to create a table that can display events uder certain dates,
states, cities, or companies. Please Help!
|