Number Formatting
Format and convert all or parts of any numeric data.
Last updated
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 ("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