Value | (Variant) Value to be formatted |
---|---|
DigitsAfterDecimal | [optional] (Variant) Numeric value indicating how many places to the right of the decimal are shown.
The default value is -1 (= the computer's regional settings are used). |
LeadingDigit | [optional] (Variant) Constant specifies whether a leading zero is shown for decimal values
-1=vbTrue - show
0=vbFalse - hide
-2=vbUseDefault - use computer default setting |
ParensForNegative | [optional] (Long) Constant specifies whether or not to place negative values within parentheses
-1=vbTrue - to place within parentheses
0=vbFalse - not to place within parentheses
-2=vbUseDefault - use computer default setting |
GroupDigits | [optional] (Long) Constant specifies whether numbers are grouped using the group delimiter specified in the control panel
-1=vbTrue - grouped
0=vbFalse - not grouped
-2=vbUseDefault - use computer default setting |
Dim sPercent
sPercent = FormatPercent(2 / 32)
' sPercent contains "6.25%"