You'll have to change them from text to a date. Try Data/ Text to Columns/
and set the import format as MDY.
--
David Biddulph


"Stross002" wrote in message
...
I have a column of dates that are formatted like: 04/19/2009.

BUT

I want them formatted as: April, 2009

I cright click and try to format the date but nothing happens?

Why? How can I change the format of these dates?

I am using Excel 07