FormatCurrency function
Summary
Format as currency.
Syntax
FormatCurrency(Expression, [ NumDigitsAfterDecimal, [ IncludeLeadingDigit, [ UseParensForNegativeNumbers, [ GroupDigits ]]]])
The FormatCurrency function syntax has these parts:
Part
Description
ExpressionRequired. Expression to be formatted.
NumDigitsAfterDecimalOptional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.
IncludeLeadingDigitOptional. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.
UseParensForNegativeNumbersOptional. Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.
GroupDigitsOptional. Tristate constant that indicates whether or not numbers are grouped by using the group delimiter specified in the computer's regional settings. See Settings section for values.
Part
Description
ExpressionRequired. Expression to be formatted.
NumDigitsAfterDecimalOptional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.
IncludeLeadingDigitOptional. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.
UseParensForNegativeNumbersOptional. Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.
GroupDigitsOptional. Tristate constant that indicates whether or not numbers are grouped by using the group delimiter specified in the computer's regional settings. See Settings section for values.