This documentation is archived and is not being maintained.

Application.International Property

Office 2007
Returns information about the current country/region and international settings. Read-only Variant.

Syntax

expression.International(Index)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
IndexOptionalVariantThe setting to be returned. Can be one of the XlApplicationInternational constants listed in the following tables.

Remarks

Brackets and Braces

IndexTypeMeaning
xlLeftBraceStringCharacter used instead of the left brace ({) in array literals.
xlLeftBracketStringCharacter used instead of the left bracket ([) in R1C1-style relative references.
xlLowerCaseColumnLetterStringLowercase column letter.
xlLowerCaseRowLetterStringLowercase row letter.
xlRightBraceStringCharacter used instead of the right brace (}) in array literals.
xlRightBracketStringCharacter used instead of the right bracket (]) in R1C1-style references.
xlUpperCaseColumnLetterStringUppercase column letter.
xlUpperCaseRowLetterStringUppercase row letter (for R1C1-style references).

Country/Region Settings

IndexTypeMeaning
xlCountryCodeLongCountry/Region version of Microsoft Excel.
xlCountrySettingLongCurrent country/region setting in the Windows Control Panel.
xlGeneralFormatNameStringName of the General number format.

Currency

IndexTypeMeaning
xlCurrencyBeforeBooleanTrue if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyCodeStringCurrency symbol.
xlCurrencyDigitsLongNumber of decimal digits to be used in currency formats.
xlCurrencyLeadingZerosBooleanTrue if leading zeros are displayed for zero currency values.
xlCurrencyMinusSignBooleanTrue if you’re using a minus sign for negative numbers; False if you’re using parentheses.
xlCurrencyNegativeLongCurrency 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.
xlCurrencySpaceBeforeBooleanTrue if a space is added before the currency symbol.
xlCurrencyTrailingZerosBooleanTrue if trailing zeros are displayed for zero currency values.
xlNoncurrencyDigitsLongNumber of decimal digits to be used in noncurrency formats.

Date and Time

IndexTypeMeaning
xl24HourClockBooleanTrue if you’re using 24-hour time; False if you’re using 12-hour time.
xl4DigitYearsBooleanTrue if you’re using four-digit years; False if you’re using two-digit years.
xlDateOrderLongOrder of date elements:
0 = month-day-year
1 = day-month-year
2 = year-month-day
xlDateSeparatorStringDate separator (/).
xlDayCodeStringDay symbol (d).
xlDayLeadingZeroBooleanTrue if a leading zero is displayed in days.
xlHourCodeStringHour symbol (h).
xlMDYBooleanTrue if the date order is month-day-year for dates displayed in the long form; False if the date order is day-month-year.
xlMinuteCodeStringMinute symbol (m).
xlMonthCodeStringMonth symbol (m).
xlMonthLeadingZeroBooleanTrue if a leading zero is displayed in months (when months are displayed as numbers).
xlMonthNameCharsLongAlways returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlSecondCodeStringSecond symbol (s).
xlTimeSeparatorStringTime separator (:).
xlTimeLeadingZeroBooleanTrue if a leading zero is displayed in times.
xlWeekdayNameCharsLongAlways returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlYearCodeStringYear symbol in number formats (y).

Measurement Systems

IndexTypeMeaning
xlMetricBooleanTrue if you’re using the metric system; False if you’re using the English measurement system.
xlNonEnglishFunctionsBooleanTrue if you’re not displaying functions in English.

Separators

IndexTypeMeaning
xlAlternateArraySeparatorStringAlternate array item separator to be used if the current array separator is the same as the decimal separator.
xlColumnSeparatorStringCharacter used to separate columns in array literals.
xlDecimalSeparatorStringDecimal separator.
xlListSeparatorStringList separator.
xlRowSeparatorStringCharacter used to separate rows in array literals.
xlThousandsSeparatorStringZero or thousands separator.

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.

Example

This example displays the international decimal separator.

Visual Basic for Applications
MsgBox "The decimal separator is " & _
    Application.International(xlDecimalSeparator)



Show: