Pivot Tables

Posted by Tim Doyle on December 18, 2001 9:04 AM

I am using Excel 2000 and creating huge pivot tables. The data I receive is in mm-dd-yy format to which I convert it to the month only use the (=month) function. What I want to do in the pivot table is convert the month's number (10 for October) to the name of the month (Oct).

Any ideas on how I do this?

Tim

Posted by Juan Pablo G. on December 18, 2001 9:08 AM

Instead of =MONTH use
=TEXT(A1,"mmm")

where A1 houses the date.

Juan Pablo G.

Posted by Mark W. on December 18, 2001 9:12 AM

Tim, instead of using the results of MONTH() in
your PivotTable use the dates themselves, and
then, Group them into months. See the Excel Help
topic for "Group or ungroup dates or times in
a PivotTable or PivotChart field."