Excel: How to Specify Language for TEXT Function

When you use TEXT Function — as part of a larger formula — to format dates in Excel, then you can use this:

=TEXT(A1,"[$-0421]dd mmmm yyyy")

The bracketed code followed by a dollar sign and a dash is a hexadecimal LCID (Language Code Identifier). The example above (0421) shows result in Indonesian (list of locale ID values can be found here).