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
|