Convert Month Display
=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,
|