How to show only Month of a mm/dd/yyyy format?

[yhoy]

I have two columns of data in format of mm/dd/yyyy. How do I convert so it
shows only "mmm"? And, is there an easy way to set up range as "1/1/2008" -
"1/31/2008" in pivot table?

Thanks...

 

[FSt1]

hi
you could add a column and use this fomula
=month(a1)
then exclude the date columun from your pivot table while including the
month column.

Regards
FSt1

 

[yhoy]

Thanks for the response.

I did it and for a1 with 07/19/2007, it returned "Jan", set up the format to
be "general", I got 7. Can you assist to solve this? for the former one, I
set the format to be "mmm" in date.

 

[David Biddulph]

Look up the MONTH function in Excel help. It returns a number, in your case
7 if you use =MONTH(A1) when A1 contains 07/19/2007. If you try to format a
cell containing the number 7 as a date, then 7 represents 7th January 1900,
and hence if the formatting is mmm you will see Jan.

If you want to see 07/19/2007 in mmm format, you can either use the formula
=A1 and format as mmm, or if you want text you can use =TEXT(A1,"mmm"). You
could, of course, merely format your A1 cell as mmm.

 

[yhoy]

Cool! How come there are so many genius on this board...:}