This page describes the characteristics of each Caspio format type. You can define format types for the entire DataPage through a Localization and/or format each field separately when configuring DataPage fields.

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 customApplies 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