grouping dates in pivot table

**lintcoop** · 01-09-2009, 11:22 AM

I am having issues grouping dates by month in the attached example. The date field is formatted as text. When I attempt to group in the pivot table, I am not given the grouping dialog box. I can't figure out why.

I would appreciate any help.

Thanks
lintcoop

**DonkeyOte** · 01-09-2009, 11:29 AM

are you saying your date values in the source sheet are text ?

if so you will need to convert them first to numerics ... 1 way:

add value 1 to a blank cell
copy said cell
highlight "dates"
edit -> paste special -> operation: Multiply -> OK

Refresh the PT & hopefully you should find you can group on the dates.

**lintcoop** · 01-09-2009, 02:50 PM

I'm sorry. I mis-spoke. They are formatted as dates. I did try your solution but it didn't work. Still formatted as dates, still won't group. Check out the attachment and see what I mean.

**VBA Noob** · 01-09-2009, 03:06 PM

Groups no problem for me in Xl 07 and Xl 03

VBA Noob

**lintcoop** · 01-09-2009, 03:09 PM

with my example file?

**VBA Noob** · 01-09-2009, 03:11 PM

with my example file?

Yes with the attached file

**lintcoop** · 01-09-2009, 03:16 PM

hmmm. Well I don't know why it isn't working for me. Not in 2003 or 2007. So I'll close this thread since it should work the way I thought it should.
Thanks for the help.
Linda