Export (0) Print
Expand All
Expand Minimize

XlApplicationInternational Enumeration

Office 2007
Specifies country/region and international settings.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xl24HourClock33True if you’re using 24-hour time; False if you’re using 12-hour time.
xl4DigitYears43True if you’re using four-digit years; False if you’re using two-digit years.
xlAlternateArraySeparator16Alternate array item separator to be used if the current array separator is the same as the decimal separator.
xlColumnSeparator14Character used to separate columns in array literals.
xlCountryCode1Country/Region version of Microsoft Excel.
xlCountrySetting2Current country/region setting in the Windows Control Panel.
xlCurrencyBefore37True if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyCode25Currency symbol.
xlCurrencyDigits27Number of decimal digits to be used in currency formats.
xlCurrencyLeadingZeros40True if leading zeros are displayed for zero currency values.
xlCurrencyMinusSign38True if you’re using a minus sign for negative numbers; False if you’re using parentheses.
xlCurrencyNegative28Currency 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.
xlCurrencySpaceBefore36True if a space is added before the currency symbol.
xlCurrencyTrailingZeros39True if trailing zeros are displayed for zero currency values.
xlDateOrder32Order of date elements:0 = month-day-year1 = day-month-year2 = year-month-day
xlDateSeparator17Date separator (/).
xlDayCode21Day symbol (d).
xlDayLeadingZero42True if a leading zero is displayed in days.
xlDecimalSeparator3Decimal separator.
xlGeneralFormatName26Name of the General number format.
xlHourCode22Hour symbol (h).
xlLeftBrace12Character used instead of the left brace ({) in array literals.
xlLeftBracket10Character used instead of the left bracket ([) in R1C1-style relative references.
xlListSeparator5List separator.
xlLowerCaseColumnLetter9Lowercase column letter.
xlLowerCaseRowLetter8Lowercase row letter.
xlMDY44True if the date order is month-day-year for dates displayed in the long form; False if the date order is day-month-year.
xlMetric35True if you’re using the metric system; False if you’re using the English measurement system.
xlMinuteCode23Minute symbol (m).
xlMonthCode20Month symbol (m).
xlMonthLeadingZero41True if a leading zero is displayed in months (when months are displayed as numbers).
xlMonthNameChars30Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlNoncurrencyDigits29Number of decimal digits to be used in noncurrency formats.
xlNonEnglishFunctions34True if you’re not displaying functions in English.
xlRightBrace13Character used instead of the right brace (}) in array literals.
xlRightBracket11Character used instead of the right bracket (]) in R1C1-style references.
xlRowSeparator15Character used to separate rows in array literals.
xlSecondCode24Second symbol (s).
xlThousandsSeparator4Zero or thousands separator.
xlTimeLeadingZero45True if a leading zero is displayed in times.
xlTimeSeparator18Time separator (:).
xlUpperCaseColumnLetter7Uppercase column letter.
xlUpperCaseRowLetter6Uppercase row letter (for R1C1-style references).
xlWeekdayNameChars31Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlYearCode19Year symbol in number formats (y).


Community Additions

ADD
Show:
© 2015 Microsoft