Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table with text
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Although you can use text fields in the Data area of a Pivot table, there are
only certain ways it can be analyzed (Count, etc.). That area shows the result of summary calculations, and you can't "average" Carnival, Circus, SideShow & Menagerie to come up with a valid result. A count of each that occur on certain dates &/or in certain cities, yes, but it will not report the text back into the data area no matter how you format those cells. Try approaching the design of your pivot table from other directions, and take advantage of the "Page" feature to get what you are looking for! HTH |:) "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Worksheet Functions | |||
Pivot Table - Wrapping Text | Excel Discussion (Misc queries) | |||
pivot table - keep text wrapped on refresh? | Excel Worksheet Functions | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |