You're welcome. Thanks for the feedback!

Kind of makes you wonder why you can't format a date in that manner!!!!!

Biff

"excel-duh?" wrote in message
...
Thank you Fred Smith and T. Valko very much for such a quick response. It
was
what I needed.

"T. Valko" wrote:

You can't unless you want to use a TEXT string as the date.

Manually typed in:

'20FEB07

Or, if the true date is already entered in a cell:

A1 = 20-Feb-07 (a true Excel DATE)

=UPPER(TEXT(A1,"ddmmmyy"))

Will return 20FEB07 as a *TEXT* string (not a true Excel DATE)

Biff

"excel-duh?" wrote in message
...
I'm a novice at Excel. How do I get the date format ddmmmyy to display
the
month portion in CAPs? Thank you any assistance you can give.