Display your dates in Month in letters only

We start from this document, where we added all the month's first days.

Don't panic! I didn't write each date one by one. I used the Fill Series trick to create my list with the fill handle.

1. Then, you select only the column A
2. I created a custom Date format to display only the months in letters

I don't need other settings for this column because my Windows is set in English.

Related articles

• Change the default Date format in Excel
• Comma or Semicolon in an Excel formula
• Convert YYYYMMDD to DD/MM/YYYY with Excel
• Convert a Text Date to a Number Date
• Displaying Days in Letters in Excel
• How to display Months in Letters in Excel?
• Capitalize the first letter in Excel (Camel Case)

Write Months in a Foreign Language

Now, we can add a language code to the Custom Date Format to write Months in another language. The list of language codes you can use is on this Wikipedia page. It's the same code as the one you must use with the TRANSLATE function 😉

The trick is to start the Custom Date Format by the language code

1. Open a bracket
2. Write the $ sign and a dash (it's compulsory)
3. Add the language code
4. Close the bracket
5. Write your custom Date format

[$-language code]mmmm

And just like that, now your months are written in French

And it's the same for any other languages, with the code in row 2.

You can notice for Germany the code $-de-de. The code $-de will also work, but some countries have many official languages, like Canada, Switzerland, ...

This is why, in this situation, it is recommended (but not compulsory) to write the country code and then the language code.

• For Canada, for example, you can have $-ca-en or $-ca-fr
• For Switzerland, you can have $-ch-fr, $-ch-de, $-ch-it

Related Articles

• The TRANSLATE function of Excel
• Displaying Days in Letters in Excel