date format
use the group feature in your pivot table and group on month.
--
Regards,
Tom Ogilvy
"****al" wrote in message
...
i have data like
Date,bill no,name,item,qty,rate, amt.,month
i have date foramt like dd/mm/yyyy what i want is if day
is 12/04/2004 than it should just display April in month
column.
i try using format cell but when i use pivot table it come
in dd/mm/yyyy format any help.
thnaks in advance.
****al
|