International Property

Applies To

Application object.

Description

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

Syntax

expression.International(Index)

expression Required. An expression that returns an Application object.

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

Index

Type

Meaning

xlCountryCode

Long

Country version of Microsoft Excel.

xlCountrySetting

Long

Current country setting in Windows Control Panel, or the country number as determined by your Macintosh system software.

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 use if the current array separator is the same as the decimal separator.

xlDateSeparator

String

Date separator (/ in U.S. version).

xlTimeSeparator

String

Time separator (: in U.S. version).

xlYearCode

String

Year symbol in number formats (y in U.S. version).

xlMonthCode

String

Month symbol (m in U.S. version).

xlDayCode

String

Day symbol (d in U.S. version).

xlHourCode

String

Hour symbol (h in U.S. version).

xlMinuteCode

String

Minute symbol (m in U.S. version).


(continued)

Index

Type

Meaning

xlSecondCode

String

Second symbol (s in U.S. version).

xlCurrencyCode

String

Currency symbol ($ in U.S. version).

xlGeneralFormatName

String

Name of the General number format.

xlCurrencyDigits

Long

Number of decimal digits to use in currency formats.

xlCurrencyNegative

Long

Currency format for negative currency values:
0 = ($x) or (x$)
1 = -$x or -x$
2 = $-x or x-$
3 = $x- or x$-
Note that the position of the currency symbol is determined by xlCurrencyBefore.

xlNoncurrencyDigits

Long

Number of decimal digits to use in noncurrency formats.

xlMonthNameChars

Long

Always returns three for backwards compatibility. In Microsoft Excel 97, short month names are read from Microsoft Windows and can have any length.

xlWeekdayNameChars

Long

Always returns three for backwards compatibility. In Microsoft Excel 97, short weekday names are read from Microsoft Windows and can have any length.

xlDateOrder

Long

Order of date elements:
0 = month-day-year
1 = day-month-year
2 = year-month-day

xl24HourClock

Boolean

True if using 24-hour time, False if using 12-hour time.

xlNonEnglishFunctions

Boolean

True if not displaying functions in English.

xlMetric

Boolean

True if using the metric system, False if 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 using a minus sign for negative numbers, False if using parentheses.

xlCurrencyTrailingZeros

Boolean

True if trailing zeros are displayed for zero currency values.


(continued)

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 using four-digit years, False if 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.


Example

This example displays the international decimal separator.

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