custom format - month as uppercase
 

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

custom format - month as uppercase
 

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"))

--
Regards,
Fred


"Glen" wrote in message
...
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

custom format - month as uppercase
 

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

Cheers,

Glen

"Fred Smith" wrote:

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"))

--
Regards,
Fred


"Glen" wrote in message
...
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