 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Text in Pivot Tables
Hi When doing a Pivot Table is it possible to have text instead of numbers in the table? If so, how can this be done. Greg Not in the data area. You can have text in the row, column or page fields. > Hi > > When doing a Pivot Table is it possible to have text instead of numbers > in the table? If so, how can this be done. > > Greg  SignatureDave Peterson If you use text it defaults to count, but that's it Peo > Not in the data area. > [quoted text clipped - 6 lines] >> >> Greg Not quite the same thing as Text IN the pivottable, though. It is using text to create the pivottable, but doesn't display text in the data field. > If you use text it defaults to count, but that's it > [quoted text clipped - 14 lines] > > > > Dave Peterson SignatureDave Peterson Thanks for your help. Apology for the duplication above. Greg
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.