Important Notice
The pages on this site contain documentation for very old MS-DOS software,
purely for historical purposes.
If you're looking for up-to-date documentation, particularly for programming,
you should not rely on the information found here, as it will be woefully
out of date.
Sample Numeric Formats
◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
Sample Numeric Formats
■ Several sample numeric formats are shown below. These examples all assume
the country code is set to 1, the United States.
Result Table
═════════════════════════════════════
FORMAT (fmt$) 5 -5 .5
═════════════════════ ═══════════ ═══════════ ═════════
Null string 5 -5 0.5
0 5 -5 1
0.00 5.00 -5.00 0.50
#,##0 5 -5 1
#,##0.00 5.00 -5.00 0.50
$#,##0;($#,##0) $5 ($5) $1
$#,##0.00;($#,##0.00) $5.00 ($5.00) $0.50
0% 500% -500% 50%
0.00% 500.00% -500.00% 50.00%
0.00E+00 5.00E+00 -5.00E+00 5.00E-01
0.00E-00 5.00E00 -5.00E00 5.00E-01
See: ◄FORMAT$ Function►