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:
|
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.