Difference between revisions of "Number Formatting"
(Marked this version for translation) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
<translate> | <translate> | ||
| + | <!--T:1--> | ||
You can use prefixes and suffixes to format numeric columns. | You can use prefixes and suffixes to format numeric columns. | ||
For each numeric column you can set: | For each numeric column you can set: | ||
| Line 10: | Line 11: | ||
* thousand separator | * thousand separator | ||
| + | <!--T:2--> | ||
Examples: | Examples: | ||
* US$ 1.300 | * US$ 1.300 | ||
| Line 18: | Line 20: | ||
* TR 7.34 % | * TR 7.34 % | ||
| + | <!--T:3--> | ||
[[File:formattingnumberscfg-en-US.PNG]] | [[File:formattingnumberscfg-en-US.PNG]] | ||
| + | <!--T:4--> | ||
[[File:formattingnumbersresult-en-US.PNG]] | [[File:formattingnumbersresult-en-US.PNG]] | ||
| + | <!--T:5--> | ||
[[File:formattingnumbersresult2-en-US.PNG]] | [[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. | ||
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.
