Change a date to text Month

[Michael]

I have a standard date (06/01/2004) I want to change
that to "June". I don't mean to just format it to
display "June" I want the cell text to be "June". I know
I have done this before but for the life of me I can't
remember or find the solution.

Any help is greatly appreciated.

Thanks

Michael

 

[Frank Kabel]

Hi
in a helper cell:
=TEXT(A1,"MMMM")

 

[Michael]

Thanks Frank.

quotes were getting me I was using single.

 

[Peter Atherton]

-----Original Message-----
I have a standard date (06/01/2004) I want to change
that to "June". I don't mean to just format it to
display "June" I want the cell text to be "June". I know
I have done this before but for the life of me I can't
remember or find the solution.

Any help is greatly appreciated.

Thanks

Michael

You need a helper column. If the date is in B1 use this
formula =TEXT(MONTH(B1),"mmmm"). Now copy this formula and
use Edit, Paste Special, VAlues and paste it in place. You
can now cut and paste the value over the original date.

But always be careful about loosing information.

Regards
Peter
(e-mail address removed)