Change a date to text Month

M

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
 
P

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
Click to expand...

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
[email protected]
 
Top