Related:
- Date convert into manth name
- Convert m3u to mp3 - Guide
- How to convert number into words in ms word in shortcut key - Guide
- Convert picture to shape powerpoint - Guide
- Convert dts to ac3 mkvtoolnix - Guide
- How to convert free fire id facebook to google - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 31, 2009 at 06:06 AM
Jul 31, 2009 at 06:06 AM
suppose following entered in A1
1/1/09
and formatted as
1-Jan-09
then in B1 copy paste this formula
=TEXT(A1,"mmm")
you will get
jan
try it for a few examples of dates.
1/1/09
and formatted as
1-Jan-09
then in B1 copy paste this formula
=TEXT(A1,"mmm")
you will get
jan
try it for a few examples of dates.