I need to know how to create a custom date format so the date is DD MMM YYYY with the MMM being all caps. I can do the basic DD MMM YYYY but the three letter month is in proper case. How do I force Excel to show my month abbreviation in all caps?

Help would be appreciated, this is for a novice user so I'd like to give him something simple or some code he can run with out knowing VBA. I'm happy to write it for him but execution must be simple.

Howdy. I don't think you can. An alternative is to have another column and enter this formula (and copy down). Assume your dates are in column D, beginning at row 6.

=UPPER(TEXT(D6,"DD MMM YYYY"))

thanks so much, I had tried various combinations of upper but not this one. I works!

I'm trying to use the UPPER function for text but I can't get it to work

=UPPER(TEXT(D6,"DD MMM YYYY"))

What would I replace DD MMM YYYY with?

I want to convert cell on my sheet to CAPS btw. I found a MACRO online but I don't want to use any MACROs

maybe =Upper(A1) ... !!!!!! :eek: