Change date formatting

[Boop914]

I have a spreadsheet that has a column of dates and a column of numbers.
The dates are entered as mm/dd/yy (01/01/03), but I have formatted the
dates so they appear as mmm-yy (Jan-03). The problem I'm having is I
want to create a pivot table that summarizes the information by month &
year (Jan-03), but because the original data included the actual date,
the pivot table has multiple entries for each month & year combination.
(For January alone, I have 73 different entries - I just want one sum
for January instead). Is there a way to change the format of the
original dates, so Excel sees them just as the month & year (Jan-03)?

 

[Andy B]

Hi

I reckon you'll have to use a helper column with something like:
=TEXT(A2,"MMM-YY")
in it. You can then Copy/Paste Special/Values and use this column instead of
the other.

Andy.

 

[Boop914]

Thank you - you're my new hero