On May 31, 1:45 pm, Jman wrote:
I have in column A numbers 1-12 all representing the months in a year.
When i put in this formula =month(B1)
i get the numbers of the months... Is there a formula that gives me only the
NAME of the month, NOT the number.

A1 equals "2" how can this number be changed to say "feb" instead of 2?
B1 2-04-07

=TEXT(DATE(1900,A1,1),"Mmm")

HTH
Kostis Vezerides