This works with regional date settings of U.S. English:
=TEXT(A1&"-1","mmmm yyyy")

If you use regional date settings of the format: d/m/y then it would stand
to reason that reversing the cell ref and the 1 should work:

=TEXT("1-"&A1,"mmmm yyyy")

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
This works with regional date settings of U.S. English:

=TEXT(A1&"-1","mmmm yyyy")

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
=TEXT(DATE(YEAR(TODAY()),A1,1),"mmmm yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"yclhk" wrote:

How to convert the month in number to the month in text ?
For example :

in cell A1 enter 2
in cell B1 display February 2009

Thanks,