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

G

Guest

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
 
B

Bob Phillips

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)
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reformat dates to yyyy/mm/dd 5
Changing date to eliminate day in format mm/dd/yyyy 1
How to convert MM/DD/YYYY to Month 2
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
Sumproduct and weekday from mm/dd/yyyy format? 3
yyyy-mm-dd date format? 3
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1

Top