Thanks Niek
That works great
"Niek Otten" wrote:
=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?
|