XlApplicationInternational Enumeration
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

XlApplicationInternational Enumeration 

Specifies country/region and international settings.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim xlApplicationInternational1 As XlApplicationInternational = XlApplicationInternational.xl24HourClock

Public Enum XlApplicationInternational
public enum XlApplicationInternational
public enum XlApplicationInternational

Member nameDescription
xl24HourClockTrue if you’re using 24-hour time; False if you’re using 12-hour time.
xl4DigitYearsTrue if you’re using four-digit years; False if you’re using two-digit years.
xlAlternateArraySeparatorAlternate array item separator to be used if the current array separator is the same as the decimal separator.
xlColumnSeparatorCharacter used to separate columns in array literals.
xlCountryCodeCountry/Region version of Microsoft Excel.
xlCountrySettingCurrent country/region setting in the Windows Control Panel.
xlCurrencyBeforeTrue if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyCodeCurrency symbol.
xlCurrencyDigitsNumber of decimal digits to be used in currency formats.
xlCurrencyLeadingZerosTrue if leading zeros are displayed for zero currency values.
xlCurrencyMinusSignTrue if you’re using a minus sign for negative numbers; False if you’re using parentheses.
xlCurrencyNegativeCurrency 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.
xlCurrencySpaceBeforeTrue if a space is added before the currency symbol.
xlCurrencyTrailingZerosTrue if trailing zeros are displayed for zero currency values.
xlDateOrderOrder of date elements:0 = month-day-year1 = day-month-year2 = year-month-day
xlDateSeparatorDate separator (/).
xlDayCodeDay symbol (d).
xlDayLeadingZeroTrue if a leading zero is displayed in days.
xlDecimalSeparatorDecimal separator.
xlGeneralFormatNameName of the General number format.
xlHourCodeHour symbol (h).
xlLeftBraceCharacter used instead of the left brace ({) in array literals.
xlLeftBracketCharacter used instead of the left bracket ([) in R1C1-style relative references.
xlListSeparatorList separator.
xlLowerCaseColumnLetterLowercase column letter.
xlLowerCaseRowLetterLowercase row letter.
xlMDYTrue if the date order is month-day-year for dates displayed in the long form; False if the date order is day-month-year.
xlMetricTrue if you’re using the metric system; False if you’re using the English measurement system.
xlMinuteCodeMinute symbol (m).
xlMonthCodeMonth symbol (m).
xlMonthLeadingZeroTrue if a leading zero is displayed in months (when months are displayed as numbers).
xlMonthNameCharsAlways returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlNoncurrencyDigitsNumber of decimal digits to be used in noncurrency formats.
xlNonEnglishFunctionsTrue if you’re not displaying functions in English.
xlRightBraceCharacter used instead of the right brace (}) in array literals.
xlRightBracketCharacter used instead of the right bracket (]) in R1C1-style references.
xlRowSeparatorCharacter used to separate rows in array literals.
xlSecondCodeSecond symbol (s).
xlThousandsSeparatorZero or thousands separator.
xlTimeLeadingZeroTrue if a leading zero is displayed in times.
xlTimeSeparatorTime separator (:).
xlUpperCaseColumnLetterUppercase column letter.
xlUpperCaseRowLetterUppercase row letter (for R1C1-style references).
xlWeekdayNameCharsAlways returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlYearCodeYear symbol in number formats (y).

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2015 Microsoft