Paul,

use an extra column in your original data with the formula (assuming
month in G:G):

=DATEVALUE("1 "&G2)

Menu Format|Cells...|Number tab, Date or Custom format as "mmm yy"

You can then base your PT on the new column.

HTH
Kostis Vezerides