upper case dates in excel

[Kyle775]

how can i display the following date 1/2/2006 as JANUARY 2, 2006
??
is there formatting for capital letters in customized formats? MMMM gives me a January the same as mmmm.

thanks for your help!

 

[Peter_SSs]

Kyle775

If you can use another cell, you could use
=UPPER(TEXT(A1,"mmmm d, yyyy"))

 

[Von Pookie]

Try:
=UPPER(TEXT(1/2/2006,"MMMM"))

 

[Kyle775]

thats great thanks both of you! i needed the entire date not just the month in capitals... its all sorted now. thanks again... someone just asked me to make that change, thought i could get away with lower case.