Convert Month Display
Hi, K****ij & Valki,
Thanks for your formula. Pls be kind to explain how the Date & Text worked
in this formula.
Thanks,
"K****ij" wrote:
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,
|