|
|
FormatNumber
Gives an expression formatted as a number
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])
The FormatNumber function syntax has these parts:
| Part |
Description |
| Expression |
Required.
Expression to be formatted. |
|
NumDigitsAfterDecimal |
Optional.
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. |
|
IncludeLeadingDigit |
Optional.
Tristate constant that indicates whether or not a leading zero is
displayed for fractional values. See Settings section for values. |
|
UseParensForNegativeNumbers |
Optional.
Tristate constant that indicates whether or not to place negative
values within parentheses. See Settings section for values. |
|
GroupDigits |
Optional.
Tristate constant that indicates whether or not numbers are grouped
using the group delimiter specified in the control panel. See
Settings section for values. |
The IncludeLeadingDigit, UseParensForNegativeNumbers, and
GroupDigits arguments have the following settings:
| Constant |
Value |
Description |
| TristateTrue |
-1 |
True |
| TristateFalse |
0 |
False |
| TristateUseDefault |
-2 |
Use the
setting from the computer's regional settings. |
When one or more of the optional arguments are omitted, the values for
omitted arguments are provided by the computer's regional settings.
|
| Note All settings
information comes from the Regional Settings Number tab. |
|
|
