Expand Minimize

Application.International Property (Excel)

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

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 following tables.

Brackets and Braces

Index

Type

Meaning

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

Meaning

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

Meaning

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’re using a minus sign for negative numbers; False if you’re using parentheses.

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.

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

Meaning

xl24HourClock

Boolean

True if you’re using 24-hour time; False if you’re using 12-hour time.

xl4DigitYears

Boolean

True if you’re using four-digit years; False if you’re 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 Microsoft 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 Microsoft Windows and can be any length.

xlYearCode

String

Year symbol in number formats (y).

Measurement Systems

Index

Type

Meaning

xlMetric

Boolean

True if you’re using the metric system; False if you’re using the English measurement system.

xlNonEnglishFunctions

Boolean

True if you’re not displaying functions in English.

Separators

Index

Type

Meaning

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’ve selected or installed.

This example displays the international decimal separator.

MsgBox "The decimal separator is " & _ 
 Application.International(xlDecimalSeparator)
Show:
© 2015 Microsoft