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)