Difference between revisions of "Number Formatting/en"
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
| + | |||
| + | |||
| + | 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]] | ||
Revision as of 15:56, 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 %
