Date Formatting

Topic

New Reply

Hello all

I would like to be able to format the dates so the month is all capital letters, say 13-MAR-2007.

When I use the custom formatting dd-mmm-yyy, I get the typical 13-Mar-2007. (I tried using MMM, which worked in an old database of mine, but no change.)

Is it possible to get Excel to do this? (uh…..easily?)

Oh yes, I do need to have actual dates, as I must sort by date.

Reply | Quote

Replies

Option 1 – use a formula such as =UPPER(TEXT(A1,”dd-mmm-yyyy”)) to convert to uppercase
Option 2 – format the cells with a font that only has uppercase characters.

I’ll be watching to see if anyone has any better suggestions.

Reply | Quote

Option 1 – use a formula such as =UPPER(TEXT(A1,”dd-mmm-yyyy”)) to convert to uppercase
Option 2 – format the cells with a font that only has uppercase characters.

I’ll be watching to see if anyone has any better suggestions.

I just might use that if there is no better way. I can put the date in a separate column, and hide it when I have to print a report.

Reply | Quote

This link http://support.microsoft.com/kb/107139 gives two solutions (one of which is similar to Catharine’s)

Reply | Quote

Note that in these solutions that the cell value ceases to be a date and is instead text that just looks like a date. It will no longer work correctly if the cell is used in calculations…

Steve

Reply | Quote

The only other way I can think of would be using code in a change event to apply a custom number format based on the month of the date. I’d use Catharine’s font idea personally.

Reply | Quote