Special date format

  • Thread starter Thread starter Pencil
  • Start date Start date
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?
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to fill cells based on Date of Arrival and Date of Departure 1
Excel Excel - Can the date format dd-mmm-yyyy display the month in upper case? 1
date/time formatting 4
How to show imported field as date format DD-MMM-YY 2
Enhancement for capitalizing dates 4
date format cell, to text format 2
Sort not working as expected 2
Macro Not Changing Date Values 7

Back
Top