next up previous contents index
Next: 8.12 Row and Column Up: 8 Defining the Appearance Previous: 8.10 Highlight Options

8.11 Currency Style 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:

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.

   figure2838
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:

  1. Select Currency Options from the Options menu.

  2. Set the parameters for Currency 1 to: 0.000.000,00, -Negative, `` DM'' (note that the leading space is significant), Suffix.

  3. 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 up previous contents index
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