Hi

The problem is that blank cells will be taken to be 01 Jan 1900, and
therefore return January as the Result.
Change your formula to
=IF(D11="","",TEXT(D1,"mmmm"))
--
Regards
Roger Govier

Salahan wrote:
I have a column in my original data that uses the formula =TEXT(D11,"mmmm")
to generate the month name, so that I can filter my pivot table by month. For
some reason the filter option on my pivot table gives 3 separate January's
and only one of those actually shows data. The other two show nothing. ( this
only accurs with January, none of the other months are affected) It is no
problem for me, but other people will be using this pivot table to generate
reports and I want to remove the duplicates to eliminate any confusion. Can
anyone help?
Salahan