You can choose from a variety of formats for displaying numbers. The display formats do not change the number itself, the way the number is stored internally, or the way it is used in calculations. Formatting just changes the way NExS displays numbers.
NExS offers two methods for changing the format of cell contents:
Format | Definition |
Scientific | Displays the number in scientific notation (exponent form) with N significant digits. |
Fixed | Displays the number using a fixed number of decimal places, specified by N. |
General | Displays the number in fixed format or scientific notation, whichever fits. Trailing zeros are not displayed. |
Dollars | Displays the number with a leading $ sign and with comma delimiters, as in $1,000,000. Negative values are displayed in parentheses. |
Comma | Displays the number with comma delimiters, as in 1,000,000. Negative values are displayed in parentheses. |
Currency N | Displays the number as indicated by the user-defined Currency N style parameters (N = 1,2,3,4). |
Percent | Display the number as a percentage, multiplying it by 100. For example, the value 0.1 is displayed as 10.00%. |
MM/DD/YY | Displays the integer portion of a date/time value in the format 08/01/91. |
DD-MMM-YY | Displays the integer portion of a date/time value as a Gregorian date, in the format 01-Aug-91. |
MMM-YY | Displays the integer portion of a date/time value in the format Aug-91. |
DD-MMM | Displays the integer portion of a date/time value in the format 01-Aug. |
DD.MM.YYYY | Displays the integer portion of a date/time value in the format 01.08.1991. |
YYYY-MM-DD | Displays the integer portion of a date/time value in the ISO 8061 date format 1991-08-01. |
HH:MM:SS | Displays the fractional portion of a date/time value in the format 06:15:30. |
Hex | Displays the integer portion of the number in base 16 with a leading 0x indicator. For example, the value 30.5 would be displayed as 0x1e. |
Logic | Displays the value 0 as 0, the value 1 as 1, and all other values as ?. |
Hidden | The cell contents are not displayed. |
Text | For cells which contains formulas, the formula itself is displayed, rather than the computed value of the cell. |
In the Cell Format dialog box there is an additional choice for Default. Default displays the number in the manner defined by the default format governing the entire spreadsheet. (The sheet default is set by the Cell Defaults... operation from the Options menu.)
For more information about cell formats and instructions for changing cell formats, refer to Chapter 8, Defining the Appearance of the Spreadsheet.