Next: 8.12 Row and Column
Up: 8 Defining the Appearance
Previous: 8.10 Highlight Options
NExS allows four user-defined formats for displaying numeric values as
currency. This is in addition to the built-in ``Dollars'' format.
The four user-defined formats are listed as Currency 1, Currency 2,
..., on the Cell Format option menus on the NExS Tool Bar, the
Cell Format dialog box, and the Cell Defaults dialog box.
(See Table 4.1 for a complete list of NExS cell formats.)
For each of the four user-defined currency formats the user may specify
the following style parameters:
- the punctuation used to denote the thousands separator and decimal point,
- whether negative values are displayed in parentheses or with a leading
minus sign,
- a string of up to seven characters such as ``USD,'' ``$,''
or ``DM'' to denote the currency's denomination, and
- whether that string is affixed to the currency value as
a prefix or a suffix.
There are four punctuation style options for the thousands separator and
decimal point. These are:
- 0,000,000.00
- - The decimal point is denoted by a period (.), and
each group of three digits to the left of the decimal is separated
by a comma (,).
- 0.000.000,00
- - The decimal point is denoted by a comma (,), and
each group of three digits to the left of the decimal is separated
by a period (.).
- 0 000 000.00
- - The decimal point is denoted by a period (.), and
each group of three digits to the left of the decimal is separated
by a space ( ).
- 0 000 000,00
- - The decimal point is denoted by a comma (,), and
each group of three digits to the left of the decimal is separated
by a space ( ).
The style parameters for the user-defined currency formats are set by
selecting the Currency Options dialog from the Options menu.
The Currency Options dialog is depicted in
Figure 8.6.
Figure 8.6: Currency Options Dialog Box
To set the currency format options such that a cell containing the value
-1234.56 displays as ``-1.234,56 DM'' when formatted as Currency 1
with 2 decimal places:
- Select Currency Options from the Options menu.
- Set the parameters for Currency 1 to: 0.000.000,00,
-Negative, `` DM'' (note that the leading space is
significant), Suffix.
- Apply your selection by clicking OK or Apply.
To set the default style parameters for the four user-defined currency
formats to your personal preferences, use NExS currency style resources
described in Appendix B.
Next: 8.12 Row and Column
Up: 8 Defining the Appearance
Previous: 8.10 Highlight Options
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999