XlApplicationInternational enumeration (Excel)
Specifies country/region and international settings.
| Name | Value | Description |
|---|---|---|
| xl24HourClock | 33 | True if you are using 24-hour time; False if you are using 12-hour time. |
| xl4DigitYears | 43 | True if you are using four-digit years; False if you are using two-digit years. |
| xlAlternateArraySeparator | 16 | Alternate array item separator to be used if the current array separator is the same as the decimal separator. |
| xlColumnSeparator | 14 | Character used to separate columns in array literals. |
| xlCountryCode | 1 | Country/Region version of Microsoft Excel. |
| xlCountrySetting | 2 | Current country/region setting in the Windows Control Panel. |
| xlCurrencyBefore | 37 | True if the currency symbol precedes the currency values; False if it follows them. |
| xlCurrencyCode | 25 | Currency symbol. |
| xlCurrencyDigits | 27 | Number of decimal digits to be used in currency formats. |
| xlCurrencyLeadingZeros | 40 | True if leading zeros are displayed for zero currency values. |
| xlCurrencyMinusSign | 38 | True if you are using a minus sign for negative numbers; False if you are using parentheses. |
| xlCurrencyNegative | 28 | Currency format for negative currency values:0 = (symbolx) or (xsymbol), 1 = -symbolx or -xsymbol, 2 = symbol-x or x-symbol, or 3 = symbolx- or xsymbol-, where symbol is the currency symbol of the country or region.Note that the position of the currency symbol is determined by xlCurrencyBefore. |
| xlCurrencySpaceBefore | 36 | True if a space is added before the currency symbol. |
| xlCurrencyTrailingZeros | 39 | True if trailing zeros are displayed for zero currency values. |
| xlDateOrder | 32 | Order of date elements: 0 = month-day-year, 1 = day-month-year, 2 = year-month-day |
| xlDateSeparator | 17 | Date separator (/). |
| xlDayCode | 21 | Day symbol (d). |
| xlDayLeadingZero | 42 | True if a leading zero is displayed in days. |
| xlDecimalSeparator | 3 | Decimal separator. |
| xlGeneralFormatName | 26 | Name of the General number format. |
| xlHourCode | 22 | Hour symbol (h). |
| xlLeftBrace | 12 | Character used instead of the left brace ({) in array literals. |
| xlLeftBracket | 10 | Character used instead of the left bracket ([) in R1C1-style relative references. |
| xlListSeparator | 5 | List separator. |
| xlLowerCaseColumnLetter | 9 | Lowercase column letter. |
| xlLowerCaseRowLetter | 8 | Lowercase row letter. |
| xlMDY | 44 | True if the date order is month-day-year for dates displayed in the long form; False if the date order is day-month-year. |
| xlMetric | 35 | True if you are using the metric system; False if you are using the English measurement system. |
| xlMinuteCode | 23 | Minute symbol (m). |
| xlMonthCode | 20 | Month symbol (m). |
| xlMonthLeadingZero | 41 | True if a leading zero is displayed in months (when months are displayed as numbers). |
| xlMonthNameChars | 30 | Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length. |
| xlNoncurrencyDigits | 29 | Number of decimal digits to be used in noncurrency formats. |
| xlNonEnglishFunctions | 34 | True if you are not displaying functions in English. |
| xlRightBrace | 13 | Character used instead of the right brace (}) in array literals. |
| xlRightBracket | 11 | Character used instead of the right bracket (]) in R1C1-style references. |
| xlRowSeparator | 15 | Character used to separate rows in array literals. |
| xlSecondCode | 24 | Second symbol (s). |
| xlThousandsSeparator | 4 | Zero or thousands separator. |
| xlTimeLeadingZero | 45 | True if a leading zero is displayed in times. |
| xlTimeSeparator | 18 | Time separator (:). |
| xlUpperCaseColumnLetter | 7 | Uppercase column letter. |
| xlUpperCaseRowLetter | 6 | Uppercase row letter (for R1C1-style references). |
| xlWeekdayNameChars | 31 | Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length. |
| xlYearCode | 19 | Year symbol in number formats (y). |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.