XlApplicationInternational enumeration
Office 2013 and later
Specifies country/region and international settings.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xl24HourClock | True if you’re using 24-hour time; False if you’re using 12-hour time. | |
| xl4DigitYears | True if you’re using four-digit years; False if you’re using two-digit years. | |
| xlAlternateArraySeparator | Alternate array item separator to be used if the current array separator is the same as the decimal separator. | |
| xlColumnSeparator | Character used to separate columns in array literals. | |
| xlCountryCode | Country/Region version of Microsoft Excel. | |
| xlCountrySetting | Current country/region setting in the Windows Control Panel. | |
| xlCurrencyBefore | True if the currency symbol precedes the currency values; False if it follows them. | |
| xlCurrencyCode | Currency symbol. | |
| xlCurrencyDigits | Number of decimal digits to be used in currency formats. | |
| xlCurrencyLeadingZeros | True if leading zeros are displayed for zero currency values. | |
| xlCurrencyMinusSign | True if you’re using a minus sign for negative numbers; False if you’re using parentheses. | |
| xlCurrencyNegative | Currency format for negative currency values:0 = (symbolx) or (xsymbol)1 = -symbolx or -xsymbol2 = symbol-x or x-symbol3 = 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 | True if a space is added before the currency symbol. | |
| xlCurrencyTrailingZeros | True if trailing zeros are displayed for zero currency values. | |
| xlDateOrder | Order of date elements:0 = month-day-year1 = day-month-year2 = year-month-day | |
| xlDateSeparator | Date separator (/). | |
| xlDayCode | Day symbol (d). | |
| xlDayLeadingZero | True if a leading zero is displayed in days. | |
| xlDecimalSeparator | Decimal separator. | |
| xlGeneralFormatName | Name of the General number format. | |
| xlHourCode | Hour symbol (h). | |
| xlLeftBrace | Character used instead of the left brace ({) in array literals. | |
| xlLeftBracket | Character used instead of the left bracket ([) in R1C1-style relative references. | |
| xlListSeparator | List separator. | |
| xlLowerCaseColumnLetter | Lowercase column letter. | |
| xlLowerCaseRowLetter | Lowercase row letter. | |
| xlMDY | 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. | |
| xlMetric | True if you’re using the metric system; False if you’re using the English measurement system. | |
| xlMinuteCode | Minute symbol (m). | |
| xlMonthCode | Month symbol (m). | |
| xlMonthLeadingZero | True if a leading zero is displayed in months (when months are displayed as numbers). | |
| xlMonthNameChars | Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length. | |
| xlNoncurrencyDigits | Number of decimal digits to be used in noncurrency formats. | |
| xlNonEnglishFunctions | True if you’re not displaying functions in English. | |
| xlRightBrace | Character used instead of the right brace (}) in array literals. | |
| xlRightBracket | Character used instead of the right bracket (]) in R1C1-style references. | |
| xlRowSeparator | Character used to separate rows in array literals. | |
| xlSecondCode | Second symbol (s). | |
| xlThousandsSeparator | Zero or thousands separator. | |
| xlTimeLeadingZero | True if a leading zero is displayed in times. | |
| xlTimeSeparator | Time separator (:). | |
| xlUpperCaseColumnLetter | Uppercase column letter. | |
| xlUpperCaseRowLetter | Uppercase row letter (for R1C1-style references). | |
| xlWeekdayNameChars | Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length. | |
| xlYearCode | Year symbol in number formats (y). |
Show: