Changing contents of cell based on Cell Format

[HeatherJ]

I have cells with individual dates-

Current contents Desired Contents
06/01/2009 June
06/14/2009 June
07/04/2009 July
07/31/2009 July

I know I can change the appearance to what I want using FORMAT CELL, but I
need to change the actual cell contents to the month rather than the
individual date. I used to do this using the TEXT to COLUMNS function, but
it's not working like it used to in my previous version.

Is there another way to do this?

Thanks,
Heather

 

[Fred Smith]

It's the Text function you want (not Text-to-Columns). Use;
=Text(a1,"mmmm")

Regards,
Fred

 

[HeatherJ]

Fantastic, thank you!

It's the Text function you want (not Text-to-Columns). Use;
=Text(a1,"mmmm")

Regards,
Fred



.

 

[Fred Smith]

You're welcome. Thanks for the feedback.

Fred.

Fantastic, thank you!