How to display Months in Letters in Excel?

How to display Months in Letters in Excel?
Last Updated on 11/06/2024
Reading time: 3 minutes

To display the months in letters in your dates, you have to create a custom date format.

  1. Do not write the months directly in letters in the cells

    This would result in text in a cell instead of a date

  2. Create a custom format of your dates to display the months in letters

    By creating your own date display code, you'll have your months in letters

Don't make the mistake of writing your Months in Letters yourself

Indeed, by doing this you are not writing a date but a text.

  1. The contents of the cell are cropped on the left, so it's text
  2. The formula bar also shows that your cells contain text and not a numeric date.
Month writting in letters convert the cell in text

Apply a Custom Date Format

In fact, Excel allows you to write your months in Letters while keeping the Date type as shown in the following image

  1. The formula bar does display a date
  2. The contents of the cells are framed on the right, so it's a numeric value
  3. The months are all written in letters
Months display in letters but its dates

To do this, we have to customize the date format.

How to construct a date in Excel

A date consists of a day, a month, and a year. Excel allows you to change the display of each of these components by changing the format of the cell.

  • d is the code for the day
  • m is the code for the month
  • y is the code for the year

The trick lies in the number of letters you'll write

  • d will write the day as a number, without the 0 for days between 1 and 9
  • dd will write the day as a number with always 2 digits, like 01 for the 1st day of the month
  • ddd will write the day in the abbreviated form of the day of the week (Mon, Tue, Wed, ...)
  • dddd will write the full day (Monday, Tuesday, Wednesday, etc.)

It's the same for the months.

  • to write the digit of the month without a 0 before the number
  • mm to write the month with always 2 digits
  • mmm to write the month in its abbreviated form (Jan, Feb, ...)
  • mmmm to write the month in letter (January, February, ....)

For the years, you can write the value in 2 or 4 digits

  • y or yy to write the year in 2 digits
  • yyy or yyyy to write the year in 4 digits
  • Tip: if you just write the letter e, Excel understands that you want to write the year in 4 digits

You can perfectly combine multiple codes. For example, you can display the month in numbers and the months in letters at the same time with the code mm mmmm.

Same date with different custom date format

Where to write the code for a date?

Write the date in the Custom Formats dialog box to display it in one of the formats listed below.

  • Either with the keyboard shortcut Ctrl + 1
  • Either by selecting the last option of the number format (More Number Formats)
Menu to open the custom number format
  1. Select the Number tab
  2. Then Custom
  3. In the Type box, enter your date format code
Dialogue box Custom Number Format

Leave a Reply

Your email address will not be published. Required fields are marked *

How to display Months in Letters in Excel?

Reading time: 3 minutes
Last Updated on 11/06/2024

To display the months in letters in your dates, you have to create a custom date format.

  1. Do not write the months directly in letters in the cells

    This would result in text in a cell instead of a date

  2. Create a custom format of your dates to display the months in letters

    By creating your own date display code, you'll have your months in letters

Don't make the mistake of writing your Months in Letters yourself

Indeed, by doing this you are not writing a date but a text.

  1. The contents of the cell are cropped on the left, so it's text
  2. The formula bar also shows that your cells contain text and not a numeric date.
Month writting in letters convert the cell in text

Apply a Custom Date Format

In fact, Excel allows you to write your months in Letters while keeping the Date type as shown in the following image

  1. The formula bar does display a date
  2. The contents of the cells are framed on the right, so it's a numeric value
  3. The months are all written in letters
Months display in letters but its dates

To do this, we have to customize the date format.

How to construct a date in Excel

A date consists of a day, a month, and a year. Excel allows you to change the display of each of these components by changing the format of the cell.

  • d is the code for the day
  • m is the code for the month
  • y is the code for the year

The trick lies in the number of letters you'll write

  • d will write the day as a number, without the 0 for days between 1 and 9
  • dd will write the day as a number with always 2 digits, like 01 for the 1st day of the month
  • ddd will write the day in the abbreviated form of the day of the week (Mon, Tue, Wed, ...)
  • dddd will write the full day (Monday, Tuesday, Wednesday, etc.)

It's the same for the months.

  • to write the digit of the month without a 0 before the number
  • mm to write the month with always 2 digits
  • mmm to write the month in its abbreviated form (Jan, Feb, ...)
  • mmmm to write the month in letter (January, February, ....)

For the years, you can write the value in 2 or 4 digits

  • y or yy to write the year in 2 digits
  • yyy or yyyy to write the year in 4 digits
  • Tip: if you just write the letter e, Excel understands that you want to write the year in 4 digits

You can perfectly combine multiple codes. For example, you can display the month in numbers and the months in letters at the same time with the code mm mmmm.

Same date with different custom date format

Where to write the code for a date?

Write the date in the Custom Formats dialog box to display it in one of the formats listed below.

  • Either with the keyboard shortcut Ctrl + 1
  • Either by selecting the last option of the number format (More Number Formats)
Menu to open the custom number format
  1. Select the Number tab
  2. Then Custom
  3. In the Type box, enter your date format code
Dialogue box Custom Number Format

Leave a Reply

Your email address will not be published. Required fields are marked *