next up previous contents index
Next: 4.6 Entering Dates and Up: 4.5 Entering Numeric Values Previous: 4.5.1 Entering Numeric Values

4.5.2 Changing the Numeric Format

   

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:

Both operations offer the following format choices:

 

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.
Table 4.1: NExS Formats

 


You can use the Hidden format to suppress display of text and numeric entries. None of the other Cell Formats affect text entries.

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.


next up previous contents index
Next: 4.6 Entering Dates and Up: 4.5 Entering Numeric Values Previous: 4.5.1 Entering Numeric Values

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999