Number functions

Note: The locale also influences the output of some Number functions; see Locale.

Note: In output, spaces in a number or amount of money are transformed into non-breaking spaces to ensure that it is not split onto different lines.

currency(value)

Formats a number as an amount of money. Which currency symbol and which thousands separator are used depends on the Locale; see Locale.

value

A number.

Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

currency(value, pattern)

Formats a number as an amount of money using a custom pattern. Which currency symbol and which thousands separator are used depends on the Locale; see Locale. For available patterns, see Number patterns.

value

A number. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

pattern

A custom pattern that may consist of symbols; see Number patterns. Note that the repetition of pattern letters plays a part in determining the exact presentation.

currencyNoSymbol(value)

Formats a number as a currency whilst omitting the currency symbol.

value

A number. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

grouped(value)

Formats a number using a thousands separator. Which separator is used depends on the Locale, see Locale.

value

A number. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.