change date format from dd/mm/yyyy to mm/yyyy

I have a column with dates in dd/mm/yyyy . I want to get rid of the dd.
although converting the date format does the job.. but the dd/mm/yyyy value
still remains on the formula bar. this then makes pivot table analysis
difficult as I want to analyse by month.

help please

Add a column for the month =MONTH(A1) and copy down, and include that in the
pivot. Maybe add a year and day column as well.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"flow23" <[email protected]> wrote in message
news:[email protected]...
> I have a column with dates in dd/mm/yyyy . I want to get rid of the dd.
> although converting the date format does the job.. but the dd/mm/yyyy
value
> still remains on the formula bar. this then makes pivot table analysis
> difficult as I want to analyse by month.
>
> help please

You could rightclick on the Date field (In the pivottable) and choose "Group and
show detail".

Then you could group my month (or month and year).

Another option might be to use another column of formulas:

=text(a2,"yyyy-mm")

And use that in the pivottable.



flow23 wrote:
>
> I have a column with dates in dd/mm/yyyy . I want to get rid of the dd.
> although converting the date format does the job.. but the dd/mm/yyyy value
> still remains on the formula bar. this then makes pivot table analysis
> difficult as I want to analyse by month.
>
> help please

--

Dave Peterson