month name

[Guest]

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

Thanks

 

[HCJ]

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

 

[Debra Dalgleish]

As answered at your later post:

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

=TEXT(A2,"mmm")

 

[Guest]

thankyou

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

.