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

(01202) 733767

Telephone No. conversion. If the Number begins with zero, this will not be recognised, so (“(0####) ######”) can be used

Last updated