custom date format to uppercase months?

[lengoldstein]

I'd like to be able to take an already-existing date like 3/14/09 and create a custom format to make it MARCH '09. "mmmm 'yy" <mmmm yy=""> results in March '09, but </mmmm>"MMMM 'yy" yields the same result. Is there any way to create an all-cap custom cell format, or do I need a macro/VB to accomplish it? If so, all suggestions gratefully received.

 

[Norie]

Sorry but the short answer is no as far as I'm aware, not using a custom format anyway.

You can get any text into upper case using the UPPER worksheet function.

 

[lengoldstein]

Sorry but the short answer is no as far as I'm aware, not using a custom format anyway.

You can get any text into upper case using the UPPER worksheet function.

Thanks for the swift reply, Norie. Yes, I was afraid custom format wouldn't work, but I thought maybe someone here knew about a secret code Bill Gates had hidden in Excel 0.97--guess not. The UPPER function won't work on its own either, since the native values I'm working with are not text but Excel date serial numbers, and UPPER(39886) is still 39886.

However, thanks to your suggestion I've just found an answer! UPPER by itself doesn't work, but UPPER(TEXT(39886,"mmmm 'yy")) does. Now to make it do it all in one step. I see daylight ahead... Thanks again!

 

[rajupkrishnan]

See example Below
Date as mentioned in cell A1 - 27-Feb-2013.

Now I want to convert the month to upper case and put the result in Cell B1.

=DAY(A1)&"-"&UPPER(TEXT(A1,"mmm")&"-"&YEAR(A1))

Result will be 27-FEB-2013

 

[FormR]

See example Below
Date as mentioned in cell A1 - 27-Feb-2013.

Now I want to convert the month to upper case and put the result in Cell B1.

=DAY(A1)&"-"&UPPER(TEXT(A1,"mmm")&"-"&YEAR(A1))

Result will be 27-FEB-2013

Try:
=UPPER(TEXT(A1,"dd-mmm-yyyy"))

 

[vanchie]

=UPPER(TEXT(TODAY(),"[$-409]mmmm dd, yyyy - ddddd"))