pound() Function

Converts the number into pounds by effectively adding a pound symbol (£), a decimal point, and one comma for every three digits preceding the decimal.


pound( number, [decimals], [no_commas] )

number: (Decimal) The number of pounds to be returned as text .

decimals: (Decimal) The number of digits after the decimal to display.

no_commas (Optional): (Integer) A flag value indicating whether commas are used as number separators. It accepts 0 or 1. The default value is 0.




If no arguments are passed, the pound symbol itself is returned as text.

If no decimals value is passed, the function uses 2 by default.


You can experiment with this function in the test box below.

Test Input

pound(3213.43,2) returns £3,213.43

Open in Github Built: Fri, Mar 11, 2022 (04:59:07 PM)

On This Page