XlApplicationInternational Enum

Definition

Specifies country/region and international settings.

public enum class XlApplicationInternational
public enum XlApplicationInternational
Public Enum XlApplicationInternational
Inheritance
XlApplicationInternational

Fields

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).

Applies to