View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Tom Bradstreet Tom Bradstreet is offline
external usenet poster
 
Posts: 6
Default Date in Pivot table question

I am using a pivot table to look at summary data for our cell phone usage. I
would like to make one big spreadsheet and view the entire year. The call
dates on the spreadsheet are mm/dd/yyyy. I would like to be able to put the
date on the Page box in the pivot table, but only use the month. Is there a
way to do this or do I have to create a new column in the spreadsheet and
split out the month there?

Thanks