=TEXT(A1, "mmmm") yeilds the full name of the month. :o)

or using Fred's suggestion and just formatting the cell as mmmm

--
Regards

Roger Govier


"steveK" wrote in message
ups.com...

Fred Smith wrote:
Month(a1) is a number. You cannot display it as text.

However, you can easily display just the month of the date. So, in
your example,
use a custom format of mmm for A1.

If you want both the date, and the month, then for a2 use:

=a1, and format as mmm

--
Regards,
Fred


Awesome! Thanks Fred.
=TEXT(A1, "mmmm") yeilds the full name of the month. :o)