View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
april april is offline
external usenet poster
 
Posts: 111
Default convert date to text month

i want to make a pivot table with the months as col headings.

my raw data looks like this:
col a col b col c col d
date -- account cost center amt

i have tried formatting col a as date (Jan 01, Feb - 01, etc) but when i
try to put the data into a pivot table with the dates as the col heading, the
pivot table ignores the Jan -01 format and puts each date as a col heading.
i know that i could sort the data and manually put in "Jan" for all the dates
between 1/1 and 1/31 but i have many rows and this is tedious.

thanks in advance for your help
aprilshowers