Reply To: Excel month names

Hi Ian,
if date is enterered in column A then:
=CHOOSE(MONTH(A1),”JAN”,”FEB”,”MAR”,”APR”,”MAY”,”JUN”,”JUL”,”AUG”,”SEP”,”OCT”,”NOV”,”DEC”)

is this you looking for?