Difference between revisions of "Number Formatting"
(Created page with "<translate> </translate>") |
(Marked this version for translation) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | <languages/> | ||
| + | |||
<translate> | <translate> | ||
| + | |||
| + | <!--T:1--> | ||
| + | You can use prefixes and suffixes to format numeric columns. | ||
| + | For each numeric column you can set: | ||
| + | * prefix | ||
| + | * suffix | ||
| + | * decimals places | ||
| + | * thousand separator | ||
| + | |||
| + | <!--T:2--> | ||
| + | Examples: | ||
| + | * US$ 1.300 | ||
| + | * $ 1300 | ||
| + | * $ 1200 K | ||
| + | * 120 M | ||
| + | * 23.5% | ||
| + | * TR 7.34 % | ||
| + | |||
| + | <!--T:3--> | ||
| + | [[File:formattingnumberscfg-en-US.PNG]] | ||
| + | |||
| + | <!--T:4--> | ||
| + | [[File:formattingnumbersresult-en-US.PNG]] | ||
| + | |||
| + | <!--T:5--> | ||
| + | [[File:formattingnumbersresult2-en-US.PNG]] | ||
| + | |||
| + | <!--T:6--> | ||
| + | Important: If you use the same prefix/sufix on the graph series the scale will show it too. | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
</translate> | </translate> | ||
Latest revision as of 11:44, 16 November 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 %
Important: If you use the same prefix/sufix on the graph series the scale will show it too.
