Converting Date format in to month format

Closed
S.Sudhir Posts 1 Registration date Tuesday July 2, 2013 Status Member Last seen July 2, 2013 - Jul 2, 2013 at 08:31 AM
 Pradi - Oct 10, 2014 at 12:31 AM
I have an issue

if 14/02/2013 format is there,i want to change 02 in to month text form.

pls guide.

2 replies

Blocked Profile
Jul 2, 2013 at 09:28 AM
It can be something as simple as....

=TEXT(A1,"mmm")

Would result in "Feb" if Cell A1 contains 2/1/2013. If you wish to have the complete month name, then use "mmmm".

I hope this gives you some direction for your specific needs.
3
It works fine, thank you
0