Previous Topic Next Topic

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.
Related:

2 responses

Answer 1 / 2
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.
Answer 2 / 2
Pradi
Oct 10, 2014 at 12:31 AM
It works fine, thank you

Similar discussions

How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response