Framework:Formatstrings: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
|- | |- | ||
|N0 | |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 | |1,235 | ||
|- | |- | ||
|N2 | |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. | |1,234.56 | ||
|- | |- | ||
|P0 | |P0 | ||
| | |The percent ("P") format specifier multiplies a number by 100 and converts it to a string that represents a percentage. | ||
|123456% | |123456% | ||
|- | |- | ||
|P2 | |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 | |123456.00% | ||
|- | |- | ||
|# | |# | ||
| | |The # format specifier converts a number to a string. | ||
|1234 | |1234 | ||
|- | |- | ||
|#.00 | |#.00 | ||
| | |The # format specifier converts a number to a string and using two fractional digits. | ||
|1234 | |1234.56 | ||
|- | |- | ||
|#,#.00 | |#,###.00 | ||
| | |The # format specifier converts a number to a string, using two fractional digits and the "," indicates a group separator. | ||
|1. | |1,234.56 | ||
|} | |} | ||
Revision as of 09:01, 24 November 2010
The following format strings can be used in input mask, analyse 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 |
