One way:

A1: 01/01/07
B1: =A1

Format B1 as mmm-yy.

Or, if you want a text string (not an XL date):

B1: =TEXT(A1,"mmm-yy")



In article . com,
" wrote:

I have a column with dates like 01/01/07 , 02/15/07 etc.
Is there any way to create a formula in the next column to display
month like JAN-07 , FEB-07 etc.
I would really appreciate help.
Thanks