cents() Function

Converts a number into its value in cents by effectively appending a cent sign to a fixed representation and one comma for every three digits preceding the decimal.

Syntax

cents( number, [decimals] )

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

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

Returns

Text

Examples

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

Test Input

cents(123412) returns 123,412.00ยข

FEEDBACK