Difference between revisions of "Number Format Specifiers"
From Keyfax Wiki
| Line 1: | Line 1: | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | |+Number Format Specifiers | + | |+ style="text-align:left;" | Number Format Specifiers |
!Expression | !Expression | ||
!Databox Value | !Databox Value | ||
Latest revision as of 12:24, 28 February 2018
| Expression | Databox Value | Result | Comments |
|---|---|---|---|
| Number Format ("C") | "12345.678" | £12,345.68 | Converts the Value into Currency format |
| Number Format ("E") | "12345.678" | 1.234568E+004 | Exponential formatting |
| Number Format ("G") | "12345.678" | 12345.678 | General formatting |
| Number Format ("F2") | "12345.678" | 12345.68 | Fixed-point formatting to 2 decimal places |
| Number Format ("N2") | "12345.678" | 12,345.68 | Number formatting to 2 decimal places |
| Number Format ("N3") | "12345.678" | 12,345.678 | Number formatting to 3 decimal places |
| Number Format ("N4") | "12345.678" | 12,345.6780 | Number formatting to 4 decimal places |
| Number Format ("P0") | "12345.678" | 1,234,568% | Percent formatting (multiplies by 100 and formats to specified number of places |
| Number Format ("(#####) #######") | 01202733767 | (01202) 733767 | Telephone No. conversion. If the Number begins with zero, this will not be recognised, so (“(0####) ######”) can be used |
