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
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