Document Properties: Number

This property tab provides number formatting settings for all fields and variables of the document.

The list on the left is set to display either the Fields or the Variables of the document.

The Field Options group is only used for Fields:

The Default from Input button sets the formatting to that of the input.

Check the Survive Reload option if the formatting is to apply to the document permanently.

The following controls for formatting values are available:

Mixed Both numbers and text. Numbers shown in original format.
Number Shows numeric values with the number of digits set in the Precision spinner box.
Integer Shows numeric values as integers.
Fixed to Shows numeric values as decimal values with the number of decimal digits set in the Decimals spinner box.
Money Shows numeric values in the format shown in the Preview text box. The default format is the Windows Currency setting.
Date Shows values that can be interpreted as dates in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Time Shows values that can be interpreted as time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Timestamp Shows values that can be interpreted as date + time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Interval Shows time as sequential time increment (e.g. format = mm shows the value as the number of minutes since calendar start ( 1899:12:30:24:00).

The Show in Percent (%) button operates on the following formats: Number, Integer and Fixed to.

Decimal and Thousand separators can be set in the edit boxes of the Separators group.

The ISO button uses the ISO standard to format date, time and timestamp values.

The System button uses the system settings for the formatting.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?