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

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" wrote:

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

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.



"FSt1" wrote:

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" wrote:

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

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.
--
David Biddulph

"yhoy" wrote in message
...
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.



"FSt1" wrote:

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" wrote:

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

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

"David Biddulph" wrote:

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.
--
David Biddulph

"yhoy" wrote in message
...
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.



"FSt1" wrote:

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" wrote:

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