Combine Win Language Code Identifier – LCID and Excel

Combine Win Language Code Identifier – LCID and Excel

This YouTube video will show you how to use Cell Formatting and Microsoft Windows Language Code Identifier (LCID) to display month names and names of weekdays in any language you prefer and, in doing so - learn a foreign language :).

Learn a foreign language with Excel

The Excel file used in making of this YouTube tutorial.

Cell Formatting in Excel can do a lot of things. And we mainly use it to ensure Cells display the same value on any computer. And the biggest impact on the way cells display comes from Regional settings. Regional settings tell Excel how to display Dates. How to display time. what is the “short Date” format like in this region? And nowhere is this as visible as it is in the date formatting. Month names or names of weekdays differ all over the globe. And so do the displayed values of cells containing date values. It is for this reason alone, that LCID really matters in Excel. It is important as it allows you to set the region of the cell. So in effect even though you open an Excel with date format “January 1st 2022” in France or Italy, you can make sure it still says  “January 1st 2022”. But as a format of the cell!