Number Format Specifiers
From Keyfax Wiki
| 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 |
