International Property

Applies To

Application Object.

Description

Returns a 45-element array containing information about the current country and international settings. Read-only.

Syntax

object.International(index)

object

Required. The Application object.

index

Optional. Specifies a single setting to return, as shown in the following table.

Index	Built-in constant	Type	Meaning
1	xlCountryCode	number	Country version of Microsoft Excel.
2	xlCountrySetting	number	Current country setting in the Microsoft Windows Control Panel or the country number as determined by your Apple system software.
3	xlDecimalSeparator	text	Decimal separator.
4	xlThousandsSeparator	text	Zero or thousands separator.
5	xlListSeparator	text	List separator.
6	xlUpperCaseRowLetter	text	Uppercase Row letter (for R1C1 references).
7	xlUpperCaseColumnLetter	text	Uppercase Column letter.
8	xlLowerCaseRowLetter	text	Lowercase Row letter.
9	xlLowerCaseColumnLetter	text	Lowercase Column letter.
10	xlLeftBracket	text	Character used instead of the left bracket ([) in R1C1 relative references.
11	xlRightBracket	text	Character used instead of the right bracket (]).
12	xlLeftBrace	text	Character used instead of the left brace ({) in array literals.
13	xlRightBrace	text	Character used instead of the right brace (}).
14	xlColumnSeparator	text	Character used to separate columns in array literals.
15	xlRowSeparator	text	Character used to separate rows.
16	xlAlternateArraySeparator	text	Alternate array item separator to use if the current array separator is the same as the decimal separator.
17	xlDateSeparator	text	Date separator (/ in US).
18	xlTimeSeparator	text	Time separator (: in US).
19	xlYearCode	text	Year symbol in number formats (y in US).
20	xlMonthCode	text	Month symbol (m).
21	xlDayCode	text	Day symbol (d).
22	xlHourCode	text	Hour symbol (h).
23	xlMinuteCode	text	Minute symbol (m).
24	xlSecondCode	text	Second symbol (s).
25	xlCurrencyCode	text	Currency symbol ($).
26	xlGeneralFormatName	text	Name of the General number format.
27	xlCurrencyDigits	number	Number of decimal digits to use in currency formats.
28	xlCurrencyNegative	number	Indicates the currency format for negative currencies: 0 = ($x) or (x$) 1 = -$x or -x$ 2 = $-x or x-$ 3 = $x- or x$- Note: The position of the currency symbol is determined by 37.
29	xlNoncurrencyDigits	number	Number of decimal digits to use in non-currency formats.
30	xlMonthNameChars	number	Number of characters to use in month names.
31	xlWeekdayNameChars	number	Number of characters to use in weekday names.
32	xlDateOrder	number	Indicates the date order: 0 = month-day-year 1 = day-month-year 2 = year-month-day
33	xl24HourClock	Boolean	True if using 24-hour time; False if using 12-hour time.
34	xlNonEnglishFunctions	Boolean	True if not displaying functions in English.
35	xlMetric	Boolean	True if using the metric system; False if using the English measurement system.
36	xlCurrencySpaceBefore	Boolean	True if adding a space before the currency symbol.
37	xlCurrencyBefore	Boolean	True if the currency symbol precedes the currency values; False if it goes after.
38	xlCurrencyMinusSign	Boolean	True if using a minus sign for negative numbers; False if using parentheses.
39	xlCurrencyTrailingZeros	Boolean	True if trailing zeros are displayed for zero currency values.
40	xlCurrencyLeadingZeros	Boolean	True if leading zeros are displayed for zero currency values.
41	xlMonthLeadingZero	Boolean	True if a leading zero is displayed in months when months are displayed as numbers.
42	xlDayLeadingZero	Boolean	True if a leading zero is displayed in days.
43	xl4DigitYears	Boolean	True if using 4-digit years; False if using 2-digit years.
44	xlMDY	Boolean	True if the date order is Month-Day-Year when dates are displayed in the long form; False if the date order is Day-Month-Year.
45	xlTimeLeadingZero	Boolean	True if the leading zero is shown in the time.

Example

This example displays the international decimal separator.

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