amount

This function rounds a number to two decimals, puts in thousand-separators when appropriate and returns it as a TEXT.

amount ( input_number ) 

The result of this function is of type TEXT.

This function has one parameter:

1. input_number, type NUMBER. The number to be formatted and converted to an amount in TEXT.

@( amount( 1000.232 ) ) 

Result: 1,000.23 (note that this is a TEXT, not a NUMBER.)

This function is supported for number values limited to MAXINT(2^31 == 2,147,483,648). Above 2,147,483,648 the result of the function is undefined (although for some languages the result might be correct). You are recommended not to use this function for values over 2,147,483,648.