Edit

Application.International property (Excel)

  • Article

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

Name Required/Optional Data type Description
Index Optional Variant The setting to be returned. Can be one of the XlApplicationInternational constants listed in the tables in the Remarks section.

Remarks

Brackets and braces

Index Type Description
xlLeftBrace String Character used instead of the left brace ({) in array literals.
xlLeftBracket String Character used instead of the left bracket ([) in R1C1-style relative references.
xlLowerCaseColumnLetter String Lowercase column letter.
xlLowerCaseRowLetter String Lowercase row letter.
xlRightBrace String Character used instead of the right brace (}) in array literals.
xlRightBracket String Character used instead of the right bracket (]) in R1C1-style references.
xlUpperCaseColumnLetter String Uppercase column letter.
xlUpperCaseRowLetter String Uppercase row letter (for R1C1-style references).

Country/Region settings

Index Type Description
xlCountryCode Long Country/region version of Microsoft Excel.
xlCountrySetting Long Current country/region setting in the Windows Control Panel.
xlGeneralFormatName String Name of the General number format.

Currency

Index Type Description
xlCurrencyBefore Boolean True if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyCode String Currency symbol.
xlCurrencyDigits Long Number of decimal digits to be used in currency formats.
xlCurrencyLeadingZeros Boolean True if leading zeros are displayed for zero currency values.
xlCurrencyMinusSign Boolean True if you are using a minus sign for negative numbers; False if you are using parentheses.
xlCurrencyNegative Long 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 Boolean True if a space is added before the currency symbol.
xlCurrencyTrailingZeros Boolean True if trailing zeros are displayed for zero currency values.
xlNoncurrencyDigits Long Number of decimal digits to be used in noncurrency formats.

Date and time

Index Type Description
xl24HourClock Boolean True if you are using 24-hour time; False if you are using 12-hour time.
xl4DigitYears Boolean True if you are using four-digit years; False if you are using two-digit years.
xlDateOrder Long Order of date elements: 0 = month-day-year, 1 = day-month-year, 2 = year-month-day
xlDateSeparator String Date separator (/).
xlDayCode String Day symbol (d).
xlDayLeadingZero Boolean True if a leading zero is displayed in days.
xlHourCode String Hour symbol (h).
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.
xlMinuteCode String Minute symbol (m).
xlMonthCode String Month symbol (m).
xlMonthLeadingZero Boolean True if a leading zero is displayed in months (when months are displayed as numbers).
xlMonthNameChars Long Always returns three characters for backward compatibility. Abbreviated month names are read from Windows and can be any length.
xlSecondCode String Second symbol (s).
xlTimeSeparator String Time separator (:).
xlTimeLeadingZero Boolean True if a leading zero is displayed in times.
xlWeekdayNameChars Long Always returns three characters for backward compatibility. Abbreviated weekday names are read from Windows and can be any length.
xlYearCode String Year symbol in number formats (y).

Measurement systems

Index Type Description
xlMetric Boolean True if you are using the metric system; False if you are using the English measurement system.
xlNonEnglishFunctions Boolean True if you are not displaying functions in English.

Separators

Index Type Description
xlAlternateArraySeparator String Alternate array item separator to be used if the current array separator is the same as the decimal separator.
xlColumnSeparator String Character used to separate columns in array literals.
xlDecimalSeparator String Decimal separator.
xlListSeparator String List separator.
xlRowSeparator String Character used to separate rows in array literals.
xlThousandsSeparator String Zero 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 have selected or installed.

Example

This example displays the international decimal separator.

MsgBox "The decimal separator is " & _ 
 Application.International(xlDecimalSeparator)

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.