International Property

                  Applies To

Returns information about the current country and international settings. Read-only Variant.

Syntax

expression.International(Index)

Elements

expression   Required. An expression that returns an Application object.

Index   Required Long. The setting to be returned. Can be one of the XlApplicationInternational constants listed in the following table.

Index Type Meaning
xlCountryCode Long Country version of Microsoft Excel.
xlCountrySetting Long Current country setting in the Windows Control Panel.
xlDecimalSeparator String Decimal separator.
xlThousandsSeparator String Zero or thousands separator.
xlListSeparator String List separator.
xlUpperCaseRowLetter String Uppercase row letter (for R1C1-style references).
xlUpperCaseColumnLetter String Uppercase column letter.
xlLowerCaseRowLetter String Lowercase row letter.
xlLowerCaseColumnLetter String Lowercase column letter.
xlLeftBracket String Character used instead of the left bracket ([) in R1C1-style relative references.
xlRightBracket String Character used instead of the right bracket (]) in R1C1-style references.
xlLeftBrace String Character used instead of the left brace ({) in array literals.
xlRightBrace String Character used instead of the right brace (}) in array literals.
xlColumnSeparator String Character used to separate columns in array literals.
xlRowSeparator String Character used to separate rows in array literals.
xlAlternateArraySeparator String Alternate array item separator to be used if the current array separator is the same as the decimal separator.
xlDateSeparator String Date separator (/).
xlTimeSeparator String Time separator (:).
xlYearCode String Year symbol in number formats (y).
xlMonthCode String Month symbol (m).
xlDayCode String Day symbol (d).
xlHourCode String Hour symbol (h).
xlMinuteCode String Minute symbol (m).
xlSecondCode String Second symbol (s).
xlCurrencyCode String Currency symbol.
xlGeneralFormatName String Name of the General number format.
xlCurrencyDigits Long Number of decimal digits to be used in currency formats.
xlCurrencyNegative Long Currency format for negative currency values:
0 = (symbolx) or (xsymbol)
1 = -symbolx or -xsymbol
2 = symbol-x or x-symbol
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.
xlNoncurrencyDigits Long Number of decimal digits to be used in noncurrency formats.
xlMonthNameChars Long Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlWeekdayNameChars Long Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlDateOrder Long Order of date elements:
0 = month-day-year
1 = day-month-year
2 = year-month-day
xl24HourClock Boolean True if you’re using 24-hour time; False if you’re using 12-hour time.
xlNonEnglishFunctions Boolean True if you’re not displaying functions in English.
xlMetric Boolean True if you’re using the metric system; False if you’re using the English measurement system.
xlCurrencySpaceBefore Boolean True if a space is added before the currency symbol.
xlCurrencyBefore Boolean True if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyMinusSign Boolean True if you’re using a minus sign for negative numbers; False if you’re using parentheses.
xlCurrencyTrailingZeros Boolean True if trailing zeros are displayed for zero currency values.
xlCurrencyLeadingZeros Boolean True if leading zeros are displayed for zero currency values.
xlMonthLeadingZero Boolean True if a leading zero is displayed in months (when months are displayed as numbers).
xlDayLeadingZero Boolean True if a leading zero is displayed in days.
xl4DigitYears Boolean True if you’re using four-digit years; False if you’re using two-digit years.
xlMDY Boolean 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.
xlTimeLeadingZero Boolean True if a leading zero is displayed in times.

Remarks

Symbols, separators, and currency formats shown in the preceding table may differ from those used in your language or geographic location and may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.