convert time into month

[rajgopal]

How can I convert "11/5/2003 12:35" into "Nov 03" using formula no
formatting

 

[Myrna Larson]

=TEXT(A1,"mmm yy")

 

[Jason Morin]

One way:

=TEXT(A1,"mmm yy")

HTH
Jason
Atlanta, GA