Date Format - converting number of month to name of month

I used custom format mmmm which works ok but when I use that data in a pivot table it reverts back to the date. Any ideas? Thx