Well Check out this formula......
I belive, it should be sufficient......

First custmosize the B1 to format(custom) in that have it as mmmm yyyy

Then put the formula in B1 as =Date(2009,A1+1,0)

Well it will return as Feburary 2009,

Now I hope that is helpful and simple....

And if you ask me why I have taken "A1+1" the i am not aware but it works
that way.....

"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,