Format Type |
Description |
Number |
Defines the presentation of numeric values.
Decimal symbol |
A period, a comma, a space or your custom symbol to separate the integral and decimal part. |
Digits after decimal |
The number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded. |
Digit grouping |
A period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on. |
Negative symbol |
Normally a minus. |
Negative number format |
Five patterns are provided, where "n" is the value and "-" will be replaced by your custom negative symbol, if any. |
Applies to: Number, AutoNumber, Text |
Currency |
Defines the presentation of numeric values representing money amounts.
Decimal symbol |
A period, a comma, a space or your custom symbol to separate the integral and decimal part. |
Digits after decimal |
The number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded. |
Digit grouping |
A period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on. |
Currency symbol |
In addition to the three major currency symbols, each region's custom symbols are available. If needed, provide your own custom symbol by entering it in the field on the right. |
Positive currency format |
Four patterns are provided, where "n" is the value. |
Negative currency format |
Sixteen patterns are provided, where "n" is the value. |
Applies to: Number, AutoNumber, Text |
Percent |
Defines the presentation of numeric values representing money amounts.
Decimal symbol |
A period, a comma, a space or your custom symbol to separate the integral and decimal part. |
Digits after decimal |
The number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded. |
Digit grouping |
A period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on. |
Percent symbol |
Normally the % sign. |
Positive percent format |
Three patterns are provided, where "n" is the value. |
Negative percent format |
Three patterns are provided, where "n" is the value and "-" will be replaced by your custom negative symbol, if any. |
Applies to: Number, AutoNumber, Text |
Long date |
Defines the long date pattern. Choose one of the many patterns available for the selected region or provide your own format. When specifying a custom format, choose one of the provided patterns first so that it appears in the custom field on the right. Then, choose custom in the end of the list to make the custom field editable, and modify the pattern as necessary. Applies to: Date/Time, Text |
Short date |
Defines the short date pattern. Choose one of the many patterns available for the selected region or provide your own by choosing custom. Applies to: Date/Time, Text |
Time |
Defines the time pattern. Choose one of the patterns available for the selected region, and provide your own AM and PM symbols if desired. Applies to: Date/Time, Text |
Yes/No |
Defines the appearance of fields that have two values only: yes or no. They can be represented as Yes/No, Y/N, 0/1, True/False, or your custom symbols. In addition, you can select distinct colors to mark yes and no values. Applies to: Text, Number, Date/Time, Yes/No |