Hi all,
I have a column of imported dates in the dd/mmm/yy format.

I need to create a pivot chart of dates but ideally need it combined
into totals for months rather than single days.

I have tried formatting and pre-formatting the dates into mmm/yy to no
avail, when I click on the cell it always comes back 01/01/05.

I have even tried text to columns, splitting the orinal date into 2
columns
dd/ and mmm/yy. But when I click on the second column the formula bar
still shows 01/01/05 and the pivot chart of this column still sees them
as seperate days not combined into months.

Can anyone help please.

Thanks,

Greg.


--
greg7468
------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=374124