Name
Application.International(XlApplicationInternational)
Synopsis
Returns an array of locale settings
. XlApplicationInternational can be one of the settings from the following table:
|
Category |
Setting |
Returns |
|---|---|---|
|
Cell references |
|
Character used instead of the left brace ({) in array literals. |
|
|
Character used instead of the left bracket ([) in R1C1-style relative references. | |
|
|
Lowercase column letter. | |
|
|
Lowercase row letter. | |
|
|
Character used instead of the right brace (}) in array literals. | |
|
|
Character used instead of the right bracket (]) in R1C1-style references. | |
|
|
Uppercase column letter. | |
|
|
Uppercase row letter (for R1C1-style references). | |
|
Country/Region |
|
Excel country/region version setting. |
|
|
Windows country/region setting. | |
|
|
Name of the General number format. | |
|
Currency |
|
True if the currency symbol precedes the currency values; False if it follows them. |
|
|
Currency symbol. | |
|
|
Number of decimal digits to be used in currency formats. | |
|
|
True if leading zeros are displayed for zero currency values. | |
|
|
True if a minus sign indicates negative numbers; False if using parentheses. | |
|
|
Currency format for negative currency values:
|
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access