Built-in Number/Data Formats
The TPA Spreadsheet supports a rich set of data formatting capabilities. When a spreadsheet is first created, all cells use the General format. As you enter data in the spreadsheet, the spreadsheet determines the type of data and applies the appropriate format (e.g., if you enter a date, a date format is applied). You apply formatting to a cell by choosing Formatting|Number... from the the TPA Spreadsheet (popup) menu .
The following table lists the built-in number formats and the result if the format is applied to a positive, negative, and decimal number.
Category Format 3 -3 .3
All | General | 3 | -3 | .3 |
Currency | $#,##0_);($#,##0) | $3 | ($3) | $0 |
$#,##0_);[RED]($#,##0) | $3 | ($3) in red | $0 | |
$#,##0.00_);($#,##0.00) | $3.00 | ($3.00) | $0.30 | |
$#,##0000.00_);[RED]$(#,##0.00) | $3.00 | ($3.00) in red | $0.30 | |
Fixed | 0 | 3 | -3 | 0 |
0.00 | 3.00 | -3.00 | 0.30 | |
#,##0 | 3 | -3 | 0 | |
#,##0.00 | 3.00 | -3.00 | 0.30 | |
#,##0_);(#,##0) | 3 | (3) | 0 | |
#,##0_);[RED](#,##0) | 3 | (3) in red | 0 | |
#,##0.00_);(#,##0.00) | 3.00 | (3.00) | 0.30 | |
#,##0.00_);[RED](#,##0.00) | 3.00 | (3.00) in red | 0.30 | |
Percent | 0% | 300% | -300% | 30% |
0.00% | 300.00% | -300.00% | 30.00% | |
Fraction | # ?/? | 3 | -3 | 2/7 |
# ??/?? | 3 | -3 | 3/10 | |
Scientific | 0.00E+00 | 3.00E+00 | -3.00E+00 | 3.00E-01 |