date format in upper case

[Tyre]

The custom format she is using now is ddmmmyy
right now it'll say: 07Apr03
she needs it to say: 07APR03

is there a custom format that can insert the text in upper case?

[phantom1975]

I don't think you can do that with a format. Instead, you can try UPPER(date here).

[Tyre]

nope, tried it, got an error
=UPPER() only takes text

it can be done in Word, but not excel because of the serial number excel uses to represent dates,
thought this was the case, but just checking with those more expert than I

thanks

[Juan Pablo González]

Use

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

or

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

if the date is in A1