Difference between revisions of "Number Formatting"

From TaticView
Jump to: navigation, search
(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

Other languages:
English • ‎português do Brasil


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 %

Formattingnumberscfg-en-US.PNG

Formattingnumbersresult-en-US.PNG

Formattingnumbersresult2-en-US.PNG

Important: If you use the same prefix/sufix on the graph series the scale will show it too.