FormatCurrency

Format a number with a currency symbol.

Syntax 
      FormatCurrency(number [,DecimalPlaces [,IncludeLeadingZero
          [,UseParenthesis [, GroupDigits]]]] )

Key
   number              The number to format.
 
   DecimalPlaces       Number of digits to display after the decimal point.

   IncludeLeadingZero  Include a leading zero for numbers <1 and > -1

   UseParenthesis      Show negative numbers in Parentheis (500) = -500

   GroupDigits         Group large numbers with commas (or the regional delimiter)

Example

Set intDemo = 150000.56
WScript.Echo FormatCurrency(intDemo,1)

“The best way to destroy the capitalist system is to debauch the currency. By a continuing process of inflation, governments can confiscate, secretly and unobserved, an important part of the wealth of their citizens” ~ John Maynard Keynes

Related:

FormatNumber - Format a number
FormatPercent - Format a number with a % symbol
FormatDateTime - Format a Date/Time value
Equivalent Powershell command: $myvar = "{0:C}" -f 1500 will display $1500


© Copyright SS64.com 1999-2013
Some rights reserved