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