Value | (Variant) Value to be formatted |
---|---|
DigitsAfterDecimal | [optional] (Variant) Numeric value specifies how many places to the right of the decimal are shown.
The default value is -1 (means that 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 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 nAngle, nSecant, sNumber
nAngle = 1.3
nSecant = 1 / Cos(nAngle)
sNumber = FormatNumber(nSecant, 4)
' Format nSecant to 4 decimal places