FormatNumber

Creates a string from a numeric value as specified by a pattern.

This function returns a String.

Arguments

Arguments	Definitions
Value	Specify the value to format.

Properties	Definitions
Pattern	Enter the pattern to be used. The following characters are supported: 0: any digit #: any digit, excluding zeroes that can be omitted .: decimal separator -: minus sign ,: grouping separator ;: separates positive and negative sub-patterns %: multiplies the value by 100 and adds % to the string ‰: multiplies the value by 1000 and adds ‰ to the string ¤: currency sign This property is also available as an argument. If you specify both, the argument value is used and the property value is ignored.

Definitions

Pattern

Enter the pattern to be used. The following characters are supported:

This property is also available as an argument. If you specify both, the argument value is used and the property value is ignored.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!