Number Formatting

Format and convert all or parts of any numeric data

These Number Format Specifier Expressions can help to display the required number(s) in a more readable or presentable format.

Number Format Expressions

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	[phone]	Telephone No. conversion. If the Number begins with zero, this will not be recognised, so (“(0####) ######”) can be used