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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Steve J. Vaughan" wrote in
message ...
Please help

I have a date if a cell in Excel, which when formatted the month is in
lower
case. 15Dec04
how do I change it so that the date appears in upper case 15DEC04?