xlApplicationInternational |
| Specifies country/region and international settings. |
| xl24HourClock | 24-hour time or 12 hour time (33) |
| xl4DigitYears | Four digit year or 2-digit year (43) |
| xlAlternateArraySeparator | Alternate array item separator to be used if the current array separator is the same as the decimal separator (16) |
| xlColumnSeparator | Character used to separate columns in array literals (14) |
| xlCountryCode | Country/Region version of Microsoft Excel (1) |
| xlCountrySetting | Current country/region setting in the Windows Control Panel (2) |
| xlCurrencyBefore | Does the currency symbol precede the currency value (37) |
| xlCurrencyCode | Currency symbol (25) |
| xlCurrencyDigits | Number of decimal digits to be used in currency formats (27) |
| xlCurrencyLeadingZeros | Are leading zeros displayed for zero currency values (40) |
| xlCurrencyMinusSign | Is a minus sign used for negative values (38) |
| xlCurrencyNegative | Currency format for negative values (28) |
| xlCurrencySpaceBefore | Is a space added before the currency symbol (36) |
| xlCurrencyTrailingZeros | Are trailing zeros displayed for zero currency values (39) |
| xlDateOrder | Order of date elements (32) |
| xlDateSeparator | Date separator (17) |
| xlDayCode | Day symbol (21) |
| xlDayLeadingZero | Are leading zeros displayed for days (42) |
| xlDecimalSeparator | Decimal separator (3) |
| xlGeneralFormatName | Name of the General number format (26) |
| xlHourCode | Hour symbol (22) |
| xlLeftBrace | Character used instead of the left brace ({) in array literals (12) |
| xlLeftBracket | Character used instead of the left bracket ([) in R1C1-style relative references (10) |
| xlListSeparator | List separator (5) |
| xlLowerCaseColumnLetter | Lowercase column letter (9) |
| xlLowerCaseRowLetter | Lowercase row letter (8) |
| xlMDY | Is the date order month-day-year for dates displayed in the long form (44) |
| xlMetric | Are you using the metric system or the imperial system (35) |
| xlMinuteCode | Minute symbol (23) |
| xlMonthCode | Month symbol (20) |
| xlMonthLeadingZero | Are leading zeros displayed for months when they are displayed as numbers (41) |
| xlMonthNameChars | Always returns three characters for backwards compatibility Abbreviated month names are read from Microsoft Windows and can be any length (30) |
| xlNoncurrencyDigits | Number of decimal digits to be used in noncurrency format (29) |
| xlNonEnglishFunctions | Are you displaying functions in English (34) |
| xlRightBrace | Character used instead of the right brace (}) in array literals (13) |
| xlRightBracket | Character used instead of the right bracket ([) in R1C1 style references (11) |
| xlRowSeparator | Character used to separate rows in array literals (15) |
| xlSecondCode | Second symbol (24) |
| xlThousandsSeparator | Zero or thousands separator (4) |
| xlTimeLeadingZero | Are leading zeros displayed in times (45) |
| xlTimeSeparator | Time separator (18) |
| xlUpperCaseColumnLetter | Uppercase column letter (7) |
| xlUpperCaseRowLetter | Uppercase row letter (6) |
| xlWeekdayNameChars | Always returns three characters for backward compatibility Abbreviated weekday names are read from Microsoft Windows and can be any length (31) |
| xlYearCode | Year symbol in number format (19) |
| xl24HourClock |
| 24-hour time or 12 hour time (33) |
| xl4DigitYears |
| Four digit year or 2-digit year (43) |
| xlAlternateArraySeparator |
| Alternate array item separator to be used if the current array separator is the same as the decimal separator (16) |
| xlColumnSeparator |
| Character used to separate columns in array literals (14) |
| xlCountryCode |
| Country/Region version of Microsoft Excel (1) |
| xlCountrySetting |
| Current country/region setting in the Windows Control Panel (2) |
| xlCurrencyBefore |
| Does the currency symbol precede the currency value (37) |
| xlCurrencyCode |
| Currency symbol (25) |
| xlCurrencyDigits |
| Number of decimal digits to be used in currency formats (27) |
| xlCurrencyLeadingZeros |
| Are leading zeros displayed for zero currency values (40) |
| xlCurrencyMinusSign |
| Is a minus sign used for negative values (38) |
| xlCurrencyNegative |
| Currency format for negative values (28) |
| xlCurrencySpaceBefore |
| Is a space added before the currency symbol (36) |
| xlCurrencyTrailingZeros |
| Are trailing zeros displayed for zero currency values (39) |
| xlDateOrder |
| Order of date elements (32) |
| xlDateSeparator |
| Date separator (17) |
| xlDayCode |
| Day symbol (21) |
| xlDayLeadingZero |
| Are leading zeros displayed for days (42) |
| xlDecimalSeparator |
| Decimal separator (3) |
| xlGeneralFormatName |
| Name of the General number format (26) |
| xlHourCode |
| Hour symbol (22) |
| xlLeftBrace |
| Character used instead of the left brace ({) in array literals (12) |
| xlLeftBracket |
| Character used instead of the left bracket ([) in R1C1-style relative references (10) |
| xlListSeparator |
| List separator (5) |
| xlLowerCaseColumnLetter |
| Lowercase column letter (9) |
| xlLowerCaseRowLetter |
| Lowercase row letter (8) |
| xlMDY |
| Is the date order month-day-year for dates displayed in the long form (44) |
| xlMetric |
| Are you using the metric system or the imperial system (35) |
| xlMinuteCode |
| Minute symbol (23) |
| xlMonthCode |
| Month symbol (20) |
| xlMonthLeadingZero |
| Are leading zeros displayed for months when they are displayed as numbers (41) |
| xlMonthNameChars |
| Always returns three characters for backwards compatibility Abbreviated month names are read from Microsoft Windows and can be any length (30) |
| xlNoncurrencyDigits |
| Number of decimal digits to be used in noncurrency format (29) |
| xlNonEnglishFunctions |
| Are you displaying functions in English (34) |
| xlRightBrace |
| Character used instead of the right brace (}) in array literals (13) |
| xlRightBracket |
| Character used instead of the right bracket ([) in R1C1 style references (11) |
| xlRowSeparator |
| Character used to separate rows in array literals (15) |
| xlSecondCode |
| Second symbol (24) |
| xlThousandsSeparator |
| Zero or thousands separator (4) |
| xlTimeLeadingZero |
| Are leading zeros displayed in times (45) |
| xlTimeSeparator |
| Time separator (18) |
| xlUpperCaseColumnLetter |
| Uppercase column letter (7) |
| xlUpperCaseRowLetter |
| Uppercase row letter (6) |
| xlWeekdayNameChars |
| Always returns three characters for backward compatibility Abbreviated weekday names are read from Microsoft Windows and can be any length (31) |
| xlYearCode |
| Year symbol in number format (19) |
| REMARKS |
| * This is used in conjunction with the Application.International property. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top