cell format and contents

Macker72

Board Regular
Joined
Mar 5, 2002
Messages
107
Hi
I have a range of dates in the dd-mmm-yy format and I would like to change these to the mmm-yy format. I can do this so they appear correctly on screen but the content of the range remains dd-mmm-yy. The problem is that i want to create a pivot table with these and group them month by month, not day by day.
Can anyone help?
Many thanks
Mac
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,118,086
Messages
5,570,136
Members
412,305
Latest member
Mozz
Top