Formatting options for numeric columns - Cloud
- Technical Communications
- Bhavesh Kumar (Inactive) (Deactivated)
- Former user (Deleted)
Overview
Numeric values can be formatted to look like currency, percentages, times, or plain numbers with decimal places, thousands, and abbreviations.
Formatting options
Acknowledgement
Advanced numeric formatting support is provided with the help of the Numerals.js library (open source, MIT license). A summary of the relevant parts of the Numerals.js documentation is repeated here.
Here are some examples of the various formatting options available for numeric columns. The first column contains possible values, the second column contains the formatting token used, and the third column shows the formatted output.
Internationalization (Language)
The format can be automatically switched to support various international differences by entering a value on Language field.
Examples
The following table illustrates how the formatting options can be applied to a given value based on the specified language:
A list of the languages available and their specification is available here.
Need support? Create a request with our support team.