Special date format

P

Pencil

I'm trying to display the month in capital letters like this: JUL 21. I've
tried to custom format using MMM dd but it displays as Jul 21. Is there a
way?
 
J

JON JON

I guess it is not possible.

As a work around you can store your date in some other place then use this
formula on any cell you want

=UPPER(TEXT(A1,"mmm dd"))

This is assuming you input your date in A1
 
Y

Yank

That worked. Thanks.

-----

I guess it is not possible.

As a work around you can store your date in some other place then use
this formula on any cell you want

=UPPER(TEXT(A1,"mmm dd"))

This is assuming you input your date in A1
Click to expand...
 
Top