Coverting Date to Text

Posted by Todd on October 12, 2001 11:59 AM

I have a date. I changed the format to "mmm" so if the date is 10/12/01, "Oct" shows up.
I need to convert that to text. If I copy and paste as value, the date's serial number shows up (e.g. 35726 or whatever). I tried using =Value(), =Text(), and nothing seems to work. And I know it can be done, because I did it three months ago!
Thanks,
Todd

Posted by Todd on October 12, 2001 12:03 PM

2nd time today

.. that i've figured out my own problem after posting. I used =text(a1,"mmm") and that worked.

Posted by IML on October 12, 2001 12:08 PM

Assuming your date is in A1, did you try
=TEXT(A1,"mmmm") or
=TEXT(A1,"mmm")