Write Months in Excel in a Foreign Language

Write Months in Excel in a Foreign Language
Last Updated on 07/05/2024
Reading time: 2 minutes

In Excel, you can write Months in any Foreign Language in the world.

  1. Customize your Date format

    You must change your Date format to display only the month

  2. Add the Foreign Code for your months

    Then, you must add a specific foreign code to your date format to write your Months in any language in the world

Display your dates in Month in letters only

We start from this document where we have added all the first days of each month.

Table with all the first days of each month

Don't panic! I didn't write each date one by one. I have used the trick of the Fill Series 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
Months in English with no additionnal settings

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

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.

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

Months in French with the addition of the French language settings

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

Months in Foreign Language

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, 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

Leave a Reply

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

Write Months in Excel in a Foreign Language

Reading time: 2 minutes
Last Updated on 07/05/2024

In Excel, you can write Months in any Foreign Language in the world.

  1. Customize your Date format

    You must change your Date format to display only the month

  2. Add the Foreign Code for your months

    Then, you must add a specific foreign code to your date format to write your Months in any language in the world

Display your dates in Month in letters only

We start from this document where we have added all the first days of each month.

Table with all the first days of each month

Don't panic! I didn't write each date one by one. I have used the trick of the Fill Series 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
Months in English with no additionnal settings

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

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.

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

Months in French with the addition of the French language settings

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

Months in Foreign Language

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, 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

Leave a Reply

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