custom format - month as uppercase

[Glen]

Hi,

Is there a custom format that will display a date with the month in
uppercase eg 13-MAR-2007?

I can acheive the same effect using an adjacent calculation column to return
a text string in this format (eg =DAY(A1) &UPPER(TEXT(A1," mmm ")) &YEAR(A1))
but this seems overkill. I would rather just format the column with the
actual data.

Thanks in advance,

Glen

 

[Fred Smith]

Formatting dates in uppercase is not supported in Excel.

As an aside, you can simplify your formula slightly by getting Text to do all
the work, ie:

=upper(text(a1,"dd mmm yyyy"))

 

[Glen]

Thanks for that. I suspected as much but didn't want to leave any stone
unturned...

Cheers,

Glen