expression.International(Index)
expression Required. An expression that returns a Spreadsheet or a ChartSpace object.
Index Required Long. The setting to be returned. Can be one of the XlApplicationInternational constants listed in the following table.
| Index | Type | Meaning |
|---|---|---|
| xlCountryCode | Long | Country/region version of the Microsoft Office Web Components. |
| xlCountrySetting | Long | Current locale setting in Control Panel. |
| 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 be used if the current array separator is the same as the decimal separator. |
| xlDateSeparator | String | Date separator (/). |
| xlTimeSeparator | String | Time separator (:). |
| xlYearCode | String | Year symbol in number formats (y). |
| xlMonthCode | String | Month symbol (m). |
| xlDayCode | String | Day symbol (d). |
| xlHourCode | String | Hour symbol (h). |
| xlMinuteCode | String | Minute symbol (m). |
| xlSecondCode | String | Second symbol (s). |
| xlCurrencyCode | String | Currency symbol. |
| xlGeneralFormatName | String | Name of the General number format. |
| xlCurrencyDigits | Long | Number of decimal digits to be used in currency formats. |
| 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. |
| xlNoncurrencyDigits | Long | Number of decimal digits to be used in non-currency formats. |
| xlMonthNameChars | Long | Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length. |
| xlWeekdayNameChars | Long | Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length. |
| xlDateOrder | Long | Order of date elements: 0 = month-day-year 1 = day-month-year 2 = year-month-day |
| xl24HourClock | Boolean | True if you’re using 24-hour time; False if you’re using 12-hour time. |
| xlNonEnglishFunctions | Boolean | True if you’re not displaying functions in English. |
| xlMetric | Boolean | True if you’re using the metric system; False if you’re 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 you’re using a minus sign for negative numbers; False if you’re using parentheses. |
| xlCurrencyTrailingZeros | Boolean | True if trailing zeros are displayed for zero currency values. |
| 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 you’re using four-digit years; False if you’re 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. |
Remarks
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.