Framework:Formatstrings: Difference between revisions

Revision as of 11:41, 26 May 2011

The following format strings can be used in input mask, analysis view or row view.

Caption	Description	Example
N0	The numeric ("N0") format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol.	1,235
N2	The numeric ("N0") format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol and using two fractional digits.	1,234.56
P0	The percent ("P") format specifier multiplies a number by 100 and converts it to a string that represents a percentage.	123456%
P2	The percent ("P") format specifier multiplies a number by 100 and converts it to a string that represents a percentage and using two fractional digits.	123456.00%
#	The # format specifier converts a number to a string.	1234
#.00	The # format specifier converts a number to a string and using two fractional digits.	1234.56
#,###.00	The # format specifier converts a number to a string, using two fractional digits and the "," indicates a group separator.	1,234.56
+#,##0.00%;-#,##0.00%;'∞'	Dezimalzahl mit 2 Nachkommastellen, positiven oder negativen Vorzeichen und bei einem Nullwert wird '∞' angezeigt.	+1.234,56 / -1.234,56 / ∞

@@ Line 35: / Line 35: @@
 |The # format specifier converts a number to a string, using two fractional digits and the "," indicates a group separator.
 |1,234.56
+|-
+|<nowiki>+#,##0.00%;-#,##0.00%;'∞'</nowiki>
+|Dezimalzahl mit 2 Nachkommastellen, positiven oder negativen Vorzeichen und bei einem Nullwert wird '∞' angezeigt.
+|<nowiki>+1.234,56 / -1.234,56 / ∞</nowiki>
 |}