If you only format a cell with dddd, what you get is the name of the day that will vary from Excel to Excel. And with this you can let your imagination run wild.īut keep in mind, this can also be very useful.

LCID are so called Locale IDs Assigned by Microsoft which you can find atįirst, you look up the language you prefer in column one and then search for the LCID Hex Code of that language in the second column. Now the LCID Hex Code is the trick that points to a language you want to display the names of the days in. However, here is something else you can do. That will format the cell to show only the name of the day on which the date occurred. Then in the Format Cells dialog box you choose Custom and in the Type field you write dddd.

Now one thing that you can do with this date is go to Cell Format either by Ctrl + 1 (one on the alphanumeric part of the keyboard) or by Right Clicking on the cell and selecting Format Cells. Rather we will take an in depth look into Cell Format and a great feature of Excel that allows you to change the names of days and months into any language you prefer, by using either the Cell Format or the TEXT function in Excel. Surprisingly, this is not a post about the Translate feature in Excel.

How to change language in excel