...
The Number tab
In the Length (ND - in the Format string) field, you can specify the total number of digits displayed for both integer and fractional parts. Rounding in the fractional part is performed according to the 1.5 as 2 rule. If this parameter is selected, the Precision parameter is required (otherwise fractional part will not be displayed).
Use the Precision (NFD - in the Format string) field to specify the number of digits in the fractional part. The source number is rounded according to the 1.5 as 2 rule.
Shift. This parameter define decimal shift: positive for left, negative for right. In other words, the source number is multiplied or divided by 10*C, where C is the absolute value of this parameter.
You can use the Shift (NS- in the Format string) field to represent for example large amounts as measured in thousands or millions. In other words, the source number is multiplied or divided by 10**C, where C is the absolute value of this parameter (C can be a negative integer).
In the Decimal Separator (NDS- in the Format string) field, enter a symbol to be used for separating integer and fractional parts of numbers. Abbreviation in round brackets, NDS, is used to designate this type of formatting in the Format string.
Use the Group Separator (NGS- in the Format string) field to enter a symbol to be used as a group separator of the groups of digits in the integer part of a number. If you specify a blank string, or a simple space, a nonbreaking space will be used as a separator.
Select the Output Leading zeros (NLZ - in the Format string) check box if you want to display zeros in front of numbers that takes less positions than Length - Precision.
Use the Presentation of zero (NZ - in the Format string) field to specify a string that represents a zero number. If not specified, the zero number is not shown (shown as a blank string). The following options are available: "-", Zero, Empty, Absent. Not applicable to numeric input fields.
Use the Grouping field (NG - in the Format string) to define how to group number's digits. The following options are available:
...
Use the Negative number presentation (NN- in the Format string) field to specify how negative numbers should be presented. The following options are available:
...
In the Number formatting template (NF- in the Format string) field, select the template to be used as number format. The template is not applied to number 0.
Use the N character as the default value.
...
The Format string wizard. The Date tab
Use the Date format (DF- in the Format string) field to specify the format of date presentation. You can select from the following options:
...
Use the Local date format (DLF- in the Format string) field to specify the local date and time format:
- 6/14/2023 (D) - day and month without leading zeros and year with the century.
- June 14, 2023 (DD) - Long date (month is spelled out).
- 6/14/2023 11:59:31 AM (DT) - Date and time time.
- June 14, 2023 6/14/2023 (DDT) - Long Date and time.
- 11:59:31 AM (T) - 12-hour time presentation; It is only valid for languages supporting this time format.
In the Blank Date Presentation (DE- in the Format string) field choose one of the following options to be used if there is no date:
...
Use the Boolean presentation. False field to select how False will be designated, you can select from the following options: False, No, Disabled.
To apply the formatting, select the corresponding check boxes.
...
If a check box for this parameter is selected, and Yes is selected as value, the negative amounts or quantities will be specially marked. You can select a background color and font color for entire rows with negative values or for particular fields by using the Select Color dialog box. Also, you can set up format for presenting negative values by using the Format string wizard dialog box.
Unfilled mark
This formatting parameter controls how the text is aligned within the field. Click in the Value column to open the drop-down list of options:
...
.
Text
This formatting parameter allows you to substitute some of the field values. Click in the Value column to open the drop-down list of options:
...
This formatting parameter controls whether the fields list items are visible. Click in the Value column to open the drop-down list of options:
...