month name

Guest · Oct 8, 2004

given 09/30/2004, how do i get sep? I am able to get the
number of the month.

Thanks

HCJ · Oct 8, 2004

Use format "mmm" for Sep, "mmmm" for September

Debra Dalgleish · Oct 8, 2004

As answered at your later post:

If the date is in cell A2, enter the following formula in another cell:

=TEXT(A2,"mmm")

Guest · Oct 11, 2004

thankyou

-----Original Message-----
Use format "mmm" for Sep, "mmmm" for September

.