A common question that's been asked several times.

You can't format a date to display all capitals. You can create a text cell,
though, which will do it, as in:

=upper(text(a1,"ddmmmyy"))

--
Regards,
Fred


"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.