Excel Date Format: How to Show Months in Uppercase

Updated 10 November 2026 · Standard formula, shown below

Excel’s built-in date formats do not include a setting that forces month names to uppercase. To display a month in uppercase, use a formula such as =UPPER(TEXT(A1,"mmmm")); it returns uppercase text, while the original date remains available in the cell.

How Excel date formatting works

Excel stores dates as serial numbers and applies a number format to control how those values appear. For example, a cell containing a date can be displayed as 8-November-2026, 11/8/2026, or November 2026 without changing the underlying date. A date number format controls the arrangement and style of date components, but it does not provide a capitalization option for month names.

In a custom date format, m represents a month when it is not being used in a time format. One m or two mm displays a number; mmm displays an abbreviated month name, and mmmm displays the full month name. For a date in November, mmmm displays “November,” not “NOVEMBER.” Changing the format to uppercase letters does not transform the month name’s text.

Convert a month name to uppercase with a formula

If cell A1 contains a valid Excel date, enter this formula in another cell:

=UPPER(TEXT(A1,"mmmm"))

TEXT formats the date using the specified format code and returns the result as text. UPPER changes the letters in that text to uppercase. For a date in November 2026, the result is NOVEMBER.

To include the day or year, put those components in the format string:

=UPPER(TEXT(A1,"dd mmmm yyyy")) returns a result such as 08 NOVEMBER 2026.
=UPPER(TEXT(A1,"mmm yyyy")) returns NOV 2026.
=UPPER(TEXT(A1,"mmmm d")) returns NOVEMBER 8.

In some regional settings, Excel uses semicolons instead of commas between function arguments. If the comma version produces a formula error, try =UPPER(TEXT(A1;"mmmm")).

Keep the result as a usable date

The formula result is text, not a date serial number. That distinction matters: Excel can no longer treat the output as a date for date arithmetic, chronological sorting, or date-based grouping in the same way it treats the original value. Keep the original date in its own cell when you need to calculate with it, and use the uppercase formula in a display column.

For example, if A2 contains a date and B2 contains =UPPER(TEXT(A2,"mmmm")), use A2 for calculations and B2 for a report heading or label. If you need both uppercase text and a sortable date value, retain both columns rather than replacing the date with the formula result.

To turn formula results into fixed text, copy the result cells and use Paste Special > Values. This removes the formulas; the pasted uppercase month names remain text and will not update if the source dates change.

Choose the right approach for your task

Only need a display format? Apply a date format such as mmmm to show the full month name. The month will use the capitalization supplied by Excel’s date formatting and regional settings.
Need uppercase in a report or label? Use UPPER(TEXT(...)). It creates the requested capitalization but returns text.
Need a reusable, sortable date? Keep the original date value and use a separate display formula. Avoid replacing the date with text.
Need a heading that updates automatically? Reference the date cell in a formula. The displayed month will change when the source date changes.

You can also use PROPER(TEXT(A1,"mmmm")) if you want initial capitalization, or LOWER(TEXT(A1,"mmmm")) for lowercase. These functions alter the text produced by TEXT; they do not alter the stored date.

Common problems and fixes

The formula shows a number or an error: Check that A1 contains a real Excel date, not text that merely looks like one. If the input is text, Excel may not recognize it consistently; convert it to a valid date before applying the formula. A cell formatted as General may show a date’s serial number when it contains a date value, but the formula above should return month text when its input is recognized.

The result is not uppercase: Confirm that UPPER wraps the entire TEXT expression, as in =UPPER(TEXT(A1,"mmmm")). A custom date format alone cannot apply this text transformation.

The month name is in another language: Month names can depend on Excel’s language and regional settings. A format code may support a locale-specific language tag in some Excel environments, but capitalization is still a separate text operation. Check the displayed month language before relying on a formula in a workbook shared across different regional settings.

The displayed date changes after opening the workbook elsewhere: Date interpretation and formatting can vary with regional settings, particularly when dates are entered as text or use ambiguous numeric forms. Store valid date values and use an unambiguous date-entry method; retain the original date separately from any text output.

Frequently Asked Questions

Can I make month names uppercase using Format Cells?
No. Format Cells can control how a date is displayed, but it has no capitalization switch for month names. Use a formula with UPPER when the visible month must be uppercase.

What formula displays the full month in uppercase?
Use =UPPER(TEXT(A1,"mmmm")), replacing A1 with the cell containing your date. The result is text, not a date value.

Can I show the uppercase month and year?
Yes. Use =UPPER(TEXT(A1,"mmmm yyyy")). For example, a date in November 2026 displays as NOVEMBER 2026.

Will the formula update when the date changes?
Yes, as long as the formula refers to the date cell. The text output recalculates when that cell’s date changes.

Can I use the uppercase result for date calculations?
Not as though it were the original date. The formula returns text, so keep the source date in another cell for calculations, sorting, and other date operations.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.