FormatNumber

Description

Formats a number according to a specified format

Function Group

Character

Syntax

string FormatNumber(number;format_string)

Input

Parameter	Description	Type	Required
number	The number to format	Number	Yes
format_string	The format to apply	String	Yes

Notes

The format of the output is dependent on the number format applied to the cell.
The color formatting strings (for example: [Red], [Blue] and so on ) cannot be applied to FormatNumber.

Examples

FormatNumber([Revenue];"#,##.00") returns 835,420.00 if [Revenue] is 835,420.