Difference between revisions of "Number Formatting"
| Line 2: | Line 2: | ||
<translate> | <translate> | ||
| + | |||
| + | You can use prefixes and suffixes to format numeric columns. | ||
| + | For each numeric column you can set: | ||
| + | * prefix | ||
| + | * suffix | ||
| + | * decimals places | ||
| + | * thousand separator | ||
| + | |||
| + | Examples: | ||
| + | * US$ 1.300 | ||
| + | * $ 1300 | ||
| + | * $ 1200 K | ||
| + | * 120 M | ||
| + | * 23.5% | ||
| + | * TR 7.34 % | ||
| + | |||
| + | [[File:formattingnumberscfg-en-US.PNG]] | ||
| + | |||
| + | [[File:formattingnumbersresult-en-US.PNG]] | ||
| + | |||
| + | [[File:formattingnumbersresult2-en-US.PNG]] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
</translate> | </translate> | ||
Revision as of 15:44, 8 October 2020
You can use prefixes and suffixes to format numeric columns.
For each numeric column you can set:
- prefix
- suffix
- decimals places
- thousand separator
Examples:
- US$ 1.300
- $ 1300
- $ 1200 K
- 120 M
- 23.5%
- TR 7.34 %
