Is there any format for date to show JAN-14 instead of Jan-14

[Khalid NGO]

Hi Everyone...

I need to know is there any format to display date i.e. (01/01/2014) as JAN-14 ?



I tried Capital letters in custom format MMM-YY but result is same as mmm-yy.

 

[Sathish KV]

Hi,

Only a formula can do it

 

[Somendra Misra]

Hi Khalid,

I don't think that's possible. But this formula can do what you want.

=UPPER(TEXT(J12,"mmm-yy"))

Considering date in J12.

Regards,

 

[Ratan Bhushan]

Hi Everyone...

I need to know is there any format to display date i.e. (01/01/2014) as JAN-14 ?

View attachment 10164

I tried Capital letters in custom format MMM-YY but result is same as mmm-yy.

Sir cant you use "=UPPER(TEXT(A1,"MMM/YY"))"

 

[Khalid NGO]

Thanks SM Sir, Sathish, and Ratan,
Actually my requirement was not a formula.

 

[NARAYANK991]

Hi Khalid ,

I know this is not an answer to your question , but it is an example of out-of-the-box thinking , given here :

http://msgroups.net/microsoft.public.excel.misc/formatting-cells-to-only-upper-ca/27652

Use the font called STENCIL.

Narayan

 

[Khalid NGO]

Thanks once again Narayan Sir for your kind help.
Link was helpful.



i have found three fonts displays text in CAPS.
Showcard Gothic
Stencil
Algerian