Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

XlApplicationInternational Enumeration

Specifies country/region and international settings.

Version Added: Excel 2007

Name

Value

Description

xl24HourClock

33

True if you’re using 24-hour time; False if you’re using 12-hour time.

xl4DigitYears

43

True if you’re using four-digit years; False if you’re 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’re using a minus sign for negative numbers; False if you’re using parentheses.

xlCurrencyNegative

28

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

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-year1 = day-month-year2 = 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’re using the metric system; False if you’re 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’re 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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.