Function Number2Display

Outputs a number with as a currency style with pence, if there are no pence these are removed

Number2Display([VALUE])

Parameters

#TypePassingDefaultNameDescription/Comments
1decimalrequiredn/aVALUEThe value to format

Returns

The formatted value as a string


Examples

Number2Display(PRICEASK)

If PRICEASK = 100000.00, then £100,000 is output
If PRICEASK = 100000.10, then £100,000.10 is output
If PRICEASK = 100000.99, then £100,000.99 is output