<%=Formatnumber(-6665.8999,3,-1,-1,0)%>
(6665.900)
An example uses all the parameters of the function Formatnumber():
The first parameter (-6665.8999) specifies the number to be formatted.
The second parameter (3) specifies the number of digits displayed after the decimal point.
The third parameter (-1) specifies whether to display leading zeros.
The fourth parameter (-1) specifies whether to use brackets for negative numbers.
The last parameter (0) specifies whether to display the delimiter
FormatNumber(ExPRession[,NumDigAfterDec[, IncLeadingDig[,UseParForNegNum[,GroupDig]]]])
| parameter | describe |
|---|---|
| Expression | Required. The expression to be formatted. |
| NumDigAfterDec | Indicates the value of the number of digits displayed on the right side of the decimal point. The default value is -1 (using the computer's locale). |
| IncLeadingDig | Optional. Indicates whether leading zero of a decimal value is displayed:
|
| UseParForNegNum | Optional. Indicates whether to place negative values in parentheses.
|
| GroupDig | Optional. Indicates whether to group numbers using the number grouping symbol specified in the computer locale.
|