Which Of The Following Characters Precedes Excel Functions

Please Notation: This commodity is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or after), this tip may not work for you lot. For a version of this tip written specifically for subsequently versions of Excel, click here: Specifying a Linguistic communication for the TEXT Function.

Specifying a Linguistic communication for the TEXT Function

Mikael uses a Danish version of Excel. If he uses the TEXT function to format dates, as in TEXT(A1,"mmmm, yyyy"), the textual format returned shows the months in Danish. He would like the months returned in English instead, and wonders how he can instruct the TEXT function as to which language information technology should use.

In that location are a couple of ways you can approach this problem. The outset is applicable if you but demand to display a engagement (and nothing else) in a cell—simply don't use the TEXT function. Y'all can hands format a jail cell to display a engagement in any language; follow these steps:

1. Select the cell (or cells) you want to format.
2. Cull Cells from the Format carte du jour. Excel displays the Format Cells dialog box.
3. Make sure the Number tab is selected.
4. Click Date at the left side of the dialog box. (Run into Effigy ane.)



Figure 1. The Number tab of the Format Cells dialog box.

5. Using the Locale drop-down list, cull a country or region that uses the date format you desire to apply. In the case of Mikael's need, picking English (United States) is a good selection. Excel modifies the appointment formats available to yous.
6. Select the desired date format.
7. Click on OK.

If you are using the TEXT worksheet function considering it is role of a larger formula, then you tin can instruct the role itself to use a different language for its output. Yous do this by including a language lawmaking (formally called an LCID) within brackets, in this manner:

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

Note that the bracketed code is within the format string, and the code itself is preceded by a dollar sign and a dash. The lawmaking is either three or 4 hexadecimal digits. (Actually, all LCIDs tin exist expressed in four hexadecimal digits, but if the leading digit is a nil, yous don't need to include it.) The example, higher up, shows how to express results in English, only you can pick whatsoever of a broad range of countries:

Code		Linguistic communication
0436		Afrikaans
041C		Albanian
045E		Amharic
0401		Arabic
042B		Armenian
044D		Assamese
082C		Azeri (Cyrillic)
042C		Azerbaijani (Latin)
042D		Basque
0423		Belarusan
0445		Bengali
0402		Bulgarian
0403		Catalan
045C		Cherokee
0804		Chinese (Simplified)
0404		Chinese (Traditional)
041A		Croatian
0405		Czech
0406		Danish
0465		Dhivehi
0413		Dutch
0466		Edo
0C09		English language (Australian)
1009		English (Canadian)
0809		English language (U.1000.)
0409		English (U.Due south.)
0425		Estonian
0438		Faroese
0464		Filipino
040B		Finnish
040C		French
0C0C		French (Canadian)
0462		Western frisian
0467		Fulfulde
0456		Galician
0437		Georgian
0407		German
0C07		German (Austrian)
0807		High german (Swiss)
0408		Greek
0447		Gujarati
0468		Hausa
0475		Hawaiian
040D		Hebrew
0439		Hindi
040E		Hungarian
0469		Ibibio
040F		Icelandic
0470		Igbo
0421		Indonesian
045D		Inuktitut
0410		Italian
0411		Japanese
044B		Kannada
0471		Kanuri
0460		Kashmiri (Arabic)
043F		Kazakh
0457		Konkani
0412		Korean
0440		Kyrgyz
0476		Latin
0426		Latvian
0427		Lithuanian
042F		Macedonian FYROM
043E		Malay
044C		Malayalam
043A		Maltese
0458		Manipuri
044E		Marathi
0450		Mongolian
0461		Nepali
0414		Norwegian Bokmal
0814		Norwegian Nynorsk
0448		Oriya
0472		Oromo
0463		Pashto
0429		Persian
0415		Polish
0416		Portuguese (Brazil)
0816		Portuguese (Portugal)
0446		Punjabi
0418		Romanaian
0419		Russian
044F		Sanskrit
0C1A		Serbian (Cyrillic)
081A		Serbian (Latin)
0459		Sindhi
045B		Sinhalese
041B		Slovak
0424		Slovene
0477		Somali
0C0A		Spanish
0441		Swahili
041D		Swedish
045A		Syriac
0428		Tajik
045F		Tamazight (Arabic)
085F		Tamazight (Latin)
0449		Tamil
0444		Tatar
044A		Telugu
041E		Thai
0873		Tigrigna (Eritrea)
0473		Tigrigna (Ethiopia)
041F		Turkish
0442		Turkmen
0422		Ukrainian
0420		Urdu
0843		Uzbek (Cyrillic)
0443		Uzbek (Latin)
042A		Vietnamese
0478		Yi
043D		Yiddish
046A		Yoruba

The inclusion of a language specifier code in your TEXT format volition work in at least Excel 2002 and Excel 2003. Information technology may work in earlier versions, besides, but hasn't been tested.

ExcelTips is your source for price-effective Microsoft Excel preparation. This tip (3299) applies to Microsoft Excel 97, 2000, 2002, and 2003. You tin can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) hither: Specifying a Linguistic communication for the TEXT Role.

Writer Bio

With more than 50 non-fiction books and numerous magazine manufactures to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more almost Allen...

More than FROM ALLEN

Decision-making Document Backdrop

Word keeps track of quite a scrap of document-related information that it refers to as "properties." Hither's how to command ...

Notice More

Exporting a Graphics Group

Need to export a graphics group from a chart so that you tin can use the group in a different programme? It's not as easy as ...

Detect More

Computing Time to come Workdays

Need to calculate the appointment that is a certain number of workdays in the hereafter? You can practice then using a couple of different ...

Find More

Source: https://excel.tips.net/T003299_Specifying_a_Language_for_the_TEXT_Function.html

Posted by: morellitobt1957.blogspot.com

Share this post