Pivot Table Problem - 'Cannot group that selection'.

Hi all,

I have a problem with Pivot Tables and I believe something to do with the format of data.

I have attached a sheet which contains the problem.

Basically there is a set of data I pull from a macro I devised. It prints out all information as a 'String' variable.

This information is displayed in columns A to C.

If I select all values from columns A to C and make a pivot table, assign month to the drop row and To-Pay and Paid to the Drop Data. I then try and group the month in the drop row but an error occurs 'Cannot group that selection'.

I tried the same thing with a set of data I wrote in columns F to H and it works fine.

Any ideas how I can solve this?

Cheers

Simon