In Excel, you can write Months in any Foreign Language in the world.
- Customize your Date format
You must change your Date format to display only the month
- 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.
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.
- Then, you select only the column A
- I created a custom Date format to display only the months in letters
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
- Open a bracket
- Write the $ sign and a dash (it's compulsory)
- Add the language code
- Close the bracket
- 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, 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
