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