date format
 

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

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

date format
 

Hi ****al,

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.


use the following formula in column "month", where the date is in B2:
=TEXT(B2;"MMMM")


arno

date format
 

There's probably an easier way, but
=--TEXT(MID(A1,4,2)&"-"&RIGHT(A1,4),"mm-yyyy")
gives short date Apr-04 if that's any help

Richard
-----Original 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
.