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