Changing contents of cell based on Cell Format

H

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
 
F

Fred Smith

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top