Number Format Specifiers

From Keyfax Wiki
Jump to: navigation, search
Number Format Specifiers
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