Excel TEXT Month: Show Dates as Month Names

How-to basics · Updated November 18, 2026

To show a date as a month name in Excel, use the TEXT function with a month format code. If A2 contains the date March 15, 2026, enter =TEXT(A2,"mmmm") in another cell; it returns March. Use "mmm" for Mar or "mm" for 03.

What the TEXT function does

TEXT converts a number into text displayed according to a format you specify. Excel stores dates as serial numbers, so a valid date can be formatted to show just its month even though the underlying value also includes a day and year. The function does not change the original cell: it returns a separate text result wherever you enter the formula.

The syntax is =TEXT(value, format_text). The first argument is the value to display, usually a date cell reference. The second is a format code enclosed in straight double quotation marks. For a month name, the key codes are mmmm and mmm. The quotation marks belong in the formula; they are not part of the displayed result.

This is useful for labels, reports, filenames assembled from dates, or combining a date with other text. If you only want to change how a date looks while keeping it as a date, a cell number format may be a better option; that distinction matters for sorting and calculations.

Month format codes to know

In a date format, the number of m characters controls how Excel displays the month:

  • m displays the month number without a leading zero, such as 3.
  • mm displays the month number with two digits, such as 03.
  • mmm displays an abbreviated month name, such as Mar.
  • mmmm displays the full month name, such as March.
  • mmmmm displays a one-letter month abbreviation, such as M for March. Some months share an initial, so this is not a unique month label.

The format code is not case-sensitive for ordinary month formatting, but it must be supplied as text in the TEXT formula. For example, using four m characters gives the full month name, not the month number. Month names usually follow Excel’s language and regional settings, so a workbook opened under another locale may display localized names.

Examples for common month displays

Assume A2 contains the real Excel date March 15, 2026. These examples return text in the result cell:

  • With the date in A2, enter =TEXT(A2,"mmm"); the result is Mar.
  • With the date in A2, enter =TEXT(A2,"mm"); the result is 03.
  • With the date in A2, enter =TEXT(A2,"mmmm yyyy"); the result is March 2026.
  • With the date in A2, enter =TEXT(A2,"mmm-yy"); the result is Mar-26.

Spaces, hyphens, and other literal characters in a format string can create readable labels. For example, the space in mmmm yyyy separates the full month from the four-digit year. For a dashboard heading that says “Month: March,” you can keep the label separate from the formula result, or include literal text in the format string using Excel’s quoting rules. Keeping labels separate is often easier to maintain.

TEXT versus changing the cell format

Choose TEXT when the result itself needs to be text—for example, when joining the month name to a sentence or using it as a label. Choose a number format when you want the cell to remain a usable date. A formatted date can still be sorted chronologically, used in date arithmetic, or referenced by other date formulas. A TEXT result is text, even if it looks like a month.

To format the original date cell in Excel for Microsoft 365 on Windows, select the cell, press Ctrl+1, choose the Number tab, select Custom, and enter mmmm in the Type box. Select OK. The cell will display the month name while retaining its underlying date value. On Excel for Mac, use Command+1 to open Format Cells; the custom number format approach is otherwise similar. The TEXT formula itself also works in Excel for Mac and Excel for the web.

Use the format-cell method for a column of dates where only the appearance should change. Use TEXT in a new column when you specifically need a text value. Do not apply a month-only display and then assume the hidden day or year has been removed: they remain part of the stored date.

Get a month number instead of a name

If a calculation needs the numeric month, use Excel’s MONTH function rather than TEXT. With a valid date in A2, enter =MONTH(A2); for March 15, 2026, the result is 3. This is a number, so it is generally more suitable for calculations, comparisons, or sorting by month number than a month-name string.

TEXT with "mm" can also show 03, but it returns text. That distinction can affect later calculations: text that looks numeric is not always treated like a number. For example, a report may need the display “03,” while a formula that checks whether a month is later than June should use a numeric month value. Pick the output based on what you will do with it next.

Group dates by month and year

A month name by itself does not identify a unique month across multiple years. March 2025 and March 2026 both become March when you use mmmm. If a list covers more than one year, include the year in the label, such as March 2026, to avoid combining different periods unintentionally.

If you need a genuine date representing the first day of each month, rather than a text label, use a date formula. With a date in A2, enter =DATE(YEAR(A2),MONTH(A2),1); for March 15, 2026, the result is the date March 1, 2026. Format that result as mmmm yyyy with a cell number format to display March 2026 while preserving a sortable date value. This is useful for monthly summaries and charts because each period remains a real date.

When summarizing transactions, a PivotTable can group date fields by months and years. That can be more robust than making a text month column, especially when the data spans years. If you use a formula-generated label instead, include both month and year and keep the original date column available for sorting and analysis.

Common problems and how to fix them

  • The formula returns an error or an unexpected result: Check that the referenced cell contains a valid Excel date, not text that only looks like one. A date imported from a file may be stored as text, and its interpretation can depend on regional date settings. Re-entering or converting the value to a real date may be necessary before formatting works.
  • The result shows a number or an odd month: The cell may contain a date serial or a value Excel cannot interpret as expected. Confirm the original date and the referenced cell. Also check that the formula uses a quoted format string, such as "mmmm", rather than an unquoted code.
  • The month is wrong for a time value: Excel’s letter m can represent a month or a minute depending on the surrounding date/time format context. For a date-only value, mmmm clearly requests the full month. When formatting times, use the appropriate time pattern and verify the result rather than assuming every m means month.
  • Month names appear in another language: TEXT follows Excel’s regional or language formatting behavior. The same formula can produce localized month names on a computer configured for another language. If a report requires a specific language, check the workbook’s environment and Excel’s supported locale-specific format options.
  • Changing the source date does not change the output: Make sure calculation is set to Automatic under Formulas > Calculation Options, or recalculate the workbook. Also check that the formula references the intended source cell.

One frequent misconception is that displaying only a month name removes the other date information. It does not: a custom number format hides parts of the displayed date, and TEXT creates a text representation, but neither rewrites the source date. Keep the full date if you may need it later.

Sorting and using month labels

Text month names sort alphabetically, not in calendar order. A list of text labels can therefore appear as April, August, December rather than January through December. Sorting a TEXT-generated month column alone is not a reliable way to produce calendar order.

For chronological sorting, sort by the original date column, or keep a real date for the first day of each month and format it to show the month and year. If a report must display month names but needs a separate sort key, retain a numeric month field or the original date in another column. This also avoids grouping January from different years together when the data crosses a year boundary.

Frequently Asked Questions

How do I show only the month name from a date in Excel?
Use the TEXT function with the mmmm format code, such as =TEXT(A2,"mmmm") when A2 contains a valid date. It returns the full month name as text.

How do I display a short month name?
Use mmm as the format code. A date in March then displays as Mar. Use mmmm when you want the full name.

How do I get the month number from a date?
Use the MONTH function on the date cell. It returns a number from 1 to 12, with January as 1 and December as 12.

Why does TEXT return a month in the wrong language?
Month names can follow the computer’s Excel language or regional settings. Check those settings and the workbook’s locale-specific format options if a report needs a particular language.

Can I show the month name without turning the date into text?
Yes. Apply a custom number format such as mmmm to the date cell. The date remains a date, so it can still be sorted and used in calculations.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.