XlApplicationInternational enumeration (Excel)

Specifies country/region and international settings.

Name	Value	Description
xl24HourClock	33	True if you are using 24-hour time; False if you are using 12-hour time.
xl4DigitYears	43	True if you are using four-digit years; False if you are using two-digit years.
xlAlternateArraySeparator	16	Alternate array item separator to be used if the current array separator is the same as the decimal separator.
xlColumnSeparator	14	Character used to separate columns in array literals.
xlCountryCode	1	Country/Region version of Microsoft Excel.
xlCountrySetting	2	Current country/region setting in the Windows Control Panel.
xlCurrencyBefore	37	True if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyCode	25	Currency symbol.
xlCurrencyDigits	27	Number of decimal digits to be used in currency formats.
xlCurrencyLeadingZeros	40	True if leading zeros are displayed for zero currency values.
xlCurrencyMinusSign	38	True if you are using a minus sign for negative numbers; False if you are using parentheses.
xlCurrencyNegative	28	Currency format for negative currency values: 0 = (symbolx) or (xsymbol), 1 = -symbolx or -xsymbol, 2 = symbol-x or x-symbol, or 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.
xlCurrencySpaceBefore	36	True if a space is added before the currency symbol.
xlCurrencyTrailingZeros	39	True if trailing zeros are displayed for zero currency values.
xlDateOrder	32	Order of date elements: 0 = month-day-year, 1 = day-month-year, 2 = year-month-day
xlDateSeparator	17	Date separator (/).
xlDayCode	21	Day symbol (d).
xlDayLeadingZero	42	True if a leading zero is displayed in days.
xlDecimalSeparator	3	Decimal separator.
xlGeneralFormatName	26	Name of the General number format.
xlHourCode	22	Hour symbol (h).
xlLeftBrace	12	Character used instead of the left brace ({) in array literals.
xlLeftBracket	10	Character used instead of the left bracket ([) in R1C1-style relative references.
xlListSeparator	5	List separator.
xlLowerCaseColumnLetter	9	Lowercase column letter.
xlLowerCaseRowLetter	8	Lowercase row letter.
xlMDY	44	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	35	True if you are using the metric system; False if you are using the English measurement system.
xlMinuteCode	23	Minute symbol (m).
xlMonthCode	20	Month symbol (m).
xlMonthLeadingZero	41	True if a leading zero is displayed in months (when months are displayed as numbers).
xlMonthNameChars	30	Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlNoncurrencyDigits	29	Number of decimal digits to be used in noncurrency formats.
xlNonEnglishFunctions	34	True if you are not displaying functions in English.
xlRightBrace	13	Character used instead of the right brace (}) in array literals.
xlRightBracket	11	Character used instead of the right bracket (]) in R1C1-style references.
xlRowSeparator	15	Character used to separate rows in array literals.
xlSecondCode	24	Second symbol (s).
xlThousandsSeparator	4	Zero or thousands separator.
xlTimeLeadingZero	45	True if a leading zero is displayed in times.
xlTimeSeparator	18	Time separator (:).
xlUpperCaseColumnLetter	7	Uppercase column letter.
xlUpperCaseRowLetter	6	Uppercase row letter (for R1C1-style references).
xlWeekdayNameChars	31	Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlYearCode	19	Year symbol in number formats (y).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.