number+0 had been carried out. The result
is precisely that of this operation if you specify only
number. If
you specify any other options, the number
is formatted as described in the following.0 causes the number to be rounded
to an integer.
FORMAT("3",4) --> " 3"
FORMAT("1.73",4,0) --> " 2"
FORMAT("1.73",4,3) --> " 1.730"
FORMAT("-.76",4,1) --> " -0.8"
FORMAT("3.03",4) --> " 3.03"
FORMAT(" - 12.73", ,4) --> "-12.7300"
FORMAT(" - 12.73") --> "-12.73"
FORMAT("0.000") --> "0"
0, the number is not in exponential notation.
If expp is not large enough to contain the
exponent, an error results.0, the exponential notation is always
used unless the exponent would be 0. (If
expp is 0,
this overrides a 0 value of
expt.) If the exponent
would be 0 when a nonzero
expp is specified, then
expp+2 blanks are supplied for the exponent
part of the result. If the exponent would be
0 and expp
is not specified, the number is not an exponential expression.FORMAT("12345.73", , ,2,2) --> "1.234573E+04"
FORMAT("12345.73", ,3, ,0) --> "1.235E+4"
FORMAT("1.234573", ,3, ,0) --> "1.235"
FORMAT("12345.73", , ,3,6) --> "12345.73"
FORMAT("1234567e5", ,3,0) --> "123456700000.000"