Excel can automatically write any month in any language without writing them one by one 😮💡This article explains the trick.

Months in Any Language in Excel

Did you know that Excel can display months in any language? This is possible by customizing the date format. Follow these steps to achieve this.

1. Start by creating a date list that includes the first day of each month.
   • You don’t have to write each date manually. Use the Fill Handle to create the list quickly.

2. Select only the dates in column A.
3. Open the Custom Number menu.
4. Apply a custom date format to display months in letters.
5. If your system is set to English, you will see the months written in English.

Write Months in Any Language in Excel

Now, we will see how to display months in any language in Excel. We will add the country code in the custom number format to the date format.

1. Open the custom number format
2. Select your previous custom code mmmm
3. Open a bracket.
4. Write the $ symbol and a dash ( - ).
5. Add the language code (e.g., fr for French).
6. Close the bracket.

Example: [$-fr]mmmm

This will display months in French. The same method works for any language, as shown in the example below.

• The list of language codes you can use is on this Wikipedia page.

For countries with multiple official languages, include both the country and language codes. This ensures accuracy.

• Canada: $-ca-en (English), $-ca-fr (French)
• Switzerland: $-ch-de (German), $-ch-fr (French), $-ch-it (Italian)

Related Articles

• Change the Default Date Format in Excel
• Why Excel Formulas Use Comma or Semi-Colon
• The TRANSLATE Function of Excel
• Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel
• Displaying Days in Letters in Excel