Creates a format string for displaying currency values, and allows locale-specific currency symbols. |
public System.String CreateCurrency(int numDecimalPlaces, boolean useNegativeSign, boolean useParensForNegatives, Color negativeColor, System.String currencySymbol, System.String localeCode, boolean currencyAtFront, boolean spaceBetween) |
Public Function CreateCurrency(ByVal numDecimalPlaces As Integer, ByVal useNegativeSign As Boolean, ByVal useParensForNegatives As Boolean, ByVal negativeColor As Color, ByVal currencySymbol As String, ByVal localeCode As String, _ ByVal currencyAtFront As Boolean, ByVal spaceBetween As Boolean) As String |
The number of decimal places to display. |
If |
If |
A color to use when displaying negative numbers. |
A string representing the currency symbol. This could be the individual Unicode character for the currency symbol (such as the dollar, pound, euro, etc) or the alphabetic representation of the currency symbol (such as USD, GBP, EUR, etc). If this value is null, no currency string or formatting will be inserted. |
A string representing the Windows locale code, used for determining display on localized versions of Excel. This is optional, and can be null. |
If the currencySymbol is non-null, this param determines if the currency string will appear before the number or after. If true, the symbol will appear before the value. If currencySymbol is null, this value is ignored. |
If the currencySymbol is non-null, and this param is true, a space will appear between the currency symbol and the value. If currencySymbol is null, this value is ignored. |
A currency format string. |
|