[Last Call] Learn how to a build a cloud-first strategyRegister Now


Date Format in Excel 2007

Posted on 2011-10-08
Medium Priority
Last Modified: 2012-06-21
I am trying to use the "Custom" method for formatting a calender date in a cell.  I would like the date to read as:  MAR 14 (the capital letters for the month is what I am after).

In the custom option of the formatting cells area, I enter the following custom string:  MMM DD, however the result is:  Mar 14.  

I have tried to use Copy and Replace Special (values only), and have also tried "Find & Replace" to find "Oct" and replace with "OCT", but nothing works.  

Thanks for any help.
Question by:Duchenne
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36937667

unfortunately, Excel does not offer a custom uppercase format for months. You could use a helper column to display the date, using

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

Be aware that this value is text, though. If you need to use the date in calculations, make sure that you refer any calculations to the original date value in column A (in this example). You can hide the column that holds the original date value to keep the spreadsheet clean.

Cheers, teylyn

Author Closing Comment

ID: 36937741
That did it.  Thanks so much.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question