That worked great for the format problem, but I have created another
problem. I am using a sumproduct formula, and it is not recognizing the date.
Below is the formula I am using.

=sumproduct(--(A10:A500=c1),--(C10:C500=c2),--(F10:F500=5))

C1= name from A DV list
C2= dates from a DV list (dates in list are same format as orginal question
ex. Aug-07)

"Mike H" wrote:

Try

=C1 in A1 and drag down as required then apply a custom format of
mmmyy

Mike

"Scott@CW" wrote:

In column C I have a list of dates (8/16/2007), I want to right a formula in
column A that would return just the month and year (OCT07). Is this possible?