Changing contents of cell based on Cell Format
 

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

Changing contents of cell based on Cell Format
 

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

Regards,
Fred

"HeatherJ" wrote in message
...
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

Changing contents of cell based on Cell Format
 

Fantastic, thank you!

"Fred Smith" wrote:

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

Regards,
Fred

"HeatherJ" wrote in message
...
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

.

Changing contents of cell based on Cell Format
 

You're welcome. Thanks for the feedback.

Fred.

"HeatherJ" wrote in message
...
Fantastic, thank you!

"Fred Smith" wrote:

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

Regards,
Fred

"HeatherJ" wrote in message
...
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

.